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;
Thursday, March 10, 2011
MySQL - Export Import Data File
Here's a code for export table data from mysql to a file:
And here's on how to import data from a file:
mysql> LOAD DATA LOCAL INFILE 'C:/hello.sql' INTO TABLE data;
And here's on how to import data from a file:
mysql> LOAD DATA LOCAL INFILE 'C:/hello.sql' INTO TABLE data;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment