mysql SQL文导出CSV

来源:互联网 发布:纳粹 飞碟知乎 编辑:程序博客网 时间:2024/05/16 10:19
mysql> select clm    -> from Table    -> where    -> limit 0,1000    -> into outfile '/tmp/xxx.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';

原创粉丝点击