“MySQL导入导出CSV格式”的版本间的差异
跳到导航
跳到搜索
(创建页面,内容为“=table= <pre> 针对 单个table menu MariaDB [mycmdb]> SELECT * INTO OUTFILE "/tmp/out.csv" FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' FRO…”) |
(没有差异)
|
2021年10月29日 (五) 08:01的版本
table
针对 单个table menu MariaDB [mycmdb]> SELECT * INTO OUTFILE "/tmp/out.csv" FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM menu; Query OK, 31 rows affected (0.014 sec) select * from myUser into outfile '/tmp/test.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';