Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Jan 092011
 

Import a CSV file into MySQL database

Answer:

To import a CSV file into the MySQL database, you can use the mysqlimport command.

# mysqlimport mytable.csv test.mytable

The above command import the CSV file into the table named `mytable` in the database `test`

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>