Simple Methods for exporting CSV files in MySQL

Below are two super simple mysql commands that can directly export csv data. If you need them, please refer to them. I recommend using phpmyadmin directly.

The Code is as follows:	Copy code
Select * from test_info Into outfile '/tmp/test.csv' Fields terminated by ', 'optionally enclosed by' "'escaped '"' Lines terminated by 'rn ';

Import CSV 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 '"' Lines terminated by 'rn ';

Another method is to use phpmyadmin, which has the function of exporting excel and csv directly.