| 代码如下 | 复制代码 |
| 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的功能哦，那种更方法哦。
时间： 2024-09-07 13:18:37