Friday, 21 December 2012

Export data from mysql database


Export the data from MySql database to a text file .

SELECT * INTO OUTFILE "G:\file.txt"
      FIELDS TERMINATED BY '\t'
      LINES TERMINATED BY '\n'
FROM test.country;

No comments:

Post a Comment