查看“MySQL导入导出CSV格式”的源代码

=table=
<pre>
针对 单个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)

-- 这里写你的sql 语句
select * from myUser 
into outfile '/tmp/test.csv' 
fields terminated by ',' optionally enclosed by '"' escaped by '"' 
lines terminated by '\r\n'; 


#一个例子
use  system;
select id,old_id,old_supplier_id,product_type,name,sales_platform,corporate_entity,insurancid from product where add_time < 16350 and supplier_id = 0 and old_id > 0 and deleted_at is null
into outfile '/tmp/test.csv' 
fields terminated by ',' optionally enclosed by '"' escaped by '"' 
lines terminated by '\r\n'; 






</pre>
=R=
[https://www.cnblogs.com/jluzhsai/p/4980210.html  Bash中使用MySQL导入导出CSV格式数据[转<nowiki>]</nowiki> ]

[[category:mysql]] [[category:dba]]