how do i import data from a csv file to my mysql database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 423,610 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,201 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 2369 | Replies: 2

•

Join Date: Jun 2004

Posts: 210

Reputation: cmills83 is an unknown quantity at this point

Rep Power: 5

Solved Threads: 0

cmills83

Offline

Posting Whiz in Training

how do i import data from a csv file to my mysql database

Aug 14th, 2007

i tried like a million things and im ready to murder someone, can someone walk me through it? thanks.

•

Join Date: Jul 2007

Location: Sofia, Bulgaria

Posts: 138

Reputation: MitkOK is an unknown quantity at this point

Rep Power: 2

Solved Threads: 10

MitkOK

Offline

Junior Poster

Re: how do i import data from a csv file to my mysql database

Aug 15th, 2007

MySQL commands :

•

You can then import it into a MySQL table by running:

load data local infile 'file.csv' into table table
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(field1, field2, field3)

The fields here are the actual tblUniq table fields that the data needs to sit in. The enclosed by and lines terminated by are optional and can help if you have columns enclosed with double-quotes such as Excel exports, etc.