Creating mysql database importing from CSV file

Discussion in 'MySQL' started by fakestar, May 18, 2007.

0
  1. #1
    Hi...

    I'm zero in mysql, all i know is import and export and basic stuff like that.

    I need help to create a database with one table, importing from a .CSV file.

    My CSV file is like:

    UIDs,Names
    9188406062983693174,name one
    1886573034124785781,name two
    15056915182967976420,other name

    And i want the mysql db with these two columns UIDs and Names.
    How can i do this?

    In "normal" way i could use this:



    Thank you!
     
    fakestar, May 18, 2007 IP
  2. Robert Allen

    Robert Allen Peon

    Messages:
    2,685
    Likes Received:
    247
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I somehow managed to do this, but i cant remember. What i can remember is that i used Excel and phpMyAdmin in cPanel.

    It isn't a easy task, i found it very hard.

    ROb
     
    Robert Allen, May 18, 2007 IP
  3. technoguy

    technoguy Notable Member

    Messages:
    4,369
    Likes Received:
    306
    Best Answers:
    0
    Trophy Points:
    205
    #3
    Send me csv file I can make sql statement for you.
     
    technoguy, May 18, 2007 IP