select * from db into outfile '/tmp/db.csv'
fields terminated by ',';
如需字段名可用以下方法:
mysql -uroot -pmysql mysql -Be "select * from db" > /tmp/db.xls
select * from db into outfile '/tmp/db.csv'
fields terminated by ',';
如需字段名可用以下方法:
mysql -uroot -pmysql mysql -Be "select * from db" > /tmp/db.xls