簡單的MySQL中匯出CSV的各種方法

代碼如下	複製代碼
select * from test_info   into outfile '/tmp/test.csv'   fields terminated by ',' optionally enclosed by '"' escaped by '"'   lines terminated by 'rn';

MySQL中匯入CSV格式資料:

代碼如下	複製代碼
load data infile '/tmp/test.csv'   into table test_info    fields terminated by ','  optionally enclosed by '"' escaped by '"'   lines terminated by 'rn';

還有一種方法，就是用phpmyadmin的有同學都知道，它帶有一個直接匯出excel和csv的功能哦，那種更方法哦。