little hint required to CSV

Discussion in 'MySQL' started by ironmankho, Aug 30, 2009.

0
  1. #1
    hi !

    i have data in CSV file in this format

    1,google.com

    now i want to import in Mysql what should i write it will create to column

    one is ID and 2nd is URL ... i am right ?

    please can any body write query structure for me !!! :eek:
     
    Last edited: Aug 30, 2009
    ironmankho, Aug 30, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Try navicat: www.navicat.com. They allow direct importing from csv, excel and about 20 other file formats. They offer a free lite version, and a free trial for their commercial version.
     
    jestep, Aug 30, 2009 IP
  3. ironmankho

    ironmankho Active Member

    Messages:
    393
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #3
    Thanks for this suggestion .it is life save trick for newbie like me
     
    ironmankho, Aug 31, 2009 IP