GMgKe586q6suSQnyqZLlGCooeWM

Pages

Search

Thursday, March 10, 2011

MySQL - Export Import Data File

Here's a code for export table data from mysql to a file:
mysql> SELECT * FROM data INTO OUTFILE 'C:/hello.sql'

And here's on how to import data from a file:
mysql> LOAD DATA LOCAL INFILE 'C:/hello.sql' INTO TABLE data;
Share/Bookmark

No comments:

Post a Comment