导出格式:
select … from 表名
into outfile “文件名”
fields terminated by “分隔符”
lines terminated by “分隔符”;
1、登录mysql
mysql -u root -p
2、导出命令;
'选择并使用 数据库'
use db2
select name, score, phone, class from scoretab;
'数据库数据==>csv文件'
select name, score, phone, class from scoretab
into outfile '/var/lib/mysql-files/scoretab_e.csv'
fields terminated by ","
lines terminated by "\n";
'退出'
exit
3、查看导出文本
'进入文件路径'
cd /var/lib/mysql-files/
vim scoretab_e.csv