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的功能哦,那種更方法哦。