Simple MySQL to export the various methods of CSV

The code is as follows	Copy Code
SELECT * FROM Test_info into outfile '/tmp/test.csv ' Fields terminated by ', ' optionally enclosed by ' "' escaped by '" ' Lines terminated by ' RN ';

To import CSV format data in MySQL:

The code is as follows	Copy Code
Load data infile '/tmp/test.csv ' into table Test_info Fields terminated by ', ' optionally enclosed by ' "' escaped by '" ' Lines terminated by ' RN ';

There is another way, that is, with the phpmyadmin of the students know that it with a direct export of Excel and CSV function Oh, the more method Oh.