Monday, May 3, 2010

mysql Dumps!

mysql> SELECT * FROM  INTO 
OUTFILE '' FIELDS TERMINATED BY ',';

We can use below query for importing data from .txt file

mysql> LOAD DATA INFILE  INTO 
TABLE ''
FIELDS TERMINATED BY ',';

No comments:

Post a Comment