Xshell下:
mysql -h服务器 -u用户名 -p密码 -e"select * from db.table where date = '2018-10-01' ;" > /usr/home/abc/csv表名.csv
或者在MySQL下进行:
select * from db.table where date = '2018-10-01'
into outfile 'my_data.csv'
fields
terminated by
Xshell下:
mysql -h服务器 -u用户名 -p密码 -e"select * from db.table where date = '2018-10-01' ;" > /usr/home/abc/csv表名.csv
或者在MySQL下进行:
select * from db.table where date = '2018-10-01'
into outfile 'my_data.csv'
fields
terminated by