insert text from file to mysql

Posted: July 22, 2012 in Database
Tags: , , , , ,

i had a file with 58000 rows in it.. was searching for a command to insert all the rows in one shot..

very simple..

LOAD DATA INFILE ‘/path/to/sample.txt’ INTO TABLE `database_name`.`table_name`

worked like a charm..

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s