https://wiki.linuxsa.org/index.php?action=history&feed=atom&title=MySQL%E5%AF%BC%E5%85%A5%E5%AF%BC%E5%87%BACSV%E6%A0%BC%E5%BC%8F
MySQL导入导出CSV格式 - 版本历史
2026-04-17T12:43:25Z
本wiki上该页面的版本历史
MediaWiki 1.43.1
https://wiki.linuxsa.org/index.php?title=MySQL%E5%AF%BC%E5%85%A5%E5%AF%BC%E5%87%BACSV%E6%A0%BC%E5%BC%8F&diff=674&oldid=prev
2021年10月29日 (五) 08:04 Evan
2021-10-29T08:04:32Z
<p></p>
<p><b>新页面</b></p><div>=table=<br />
<pre><br />
针对 单个table menu<br />
MariaDB [mycmdb]> SELECT * INTO OUTFILE "/tmp/out.csv" FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM menu;<br />
Query OK, 31 rows affected (0.014 sec)<br />
<br />
-- 这里写你的sql 语句<br />
select * from myUser <br />
into outfile '/tmp/test.csv' <br />
fields terminated by ',' optionally enclosed by '"' escaped by '"' <br />
lines terminated by '\r\n'; <br />
<br />
<br />
#一个例子<br />
use system;<br />
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<br />
into outfile '/tmp/test.csv' <br />
fields terminated by ',' optionally enclosed by '"' escaped by '"' <br />
lines terminated by '\r\n'; <br />
<br />
<br />
<br />
<br />
<br />
<br />
</pre><br />
=R=<br />
[https://www.cnblogs.com/jluzhsai/p/4980210.html Bash中使用MySQL导入导出CSV格式数据[转<nowiki>]</nowiki> ]<br />
<br />
[[category:mysql]] [[category:dba]]</div>
Evan