第六章：MySQL高级进阶-导出数据

直接学习：https://edu.csdn.net/course/play/27328/370717

导出数据

#导出数据的几种方式：

方法一:

select * from employee into outfile 'C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Uploads\\employee.txt'
fields terminated by ','
enclosed by ""
lines terminated by'\r\n';
           

方法二:

/*导出mydb数据库（含数据）*/
mysqldump -h localhost -u root -p mylb >d:/mylb.sql
/*导出mydb数据库，忽略contacts表*/
mysqldump -h localhost -u root -p mylb --ignore-table mylb.area >d:/mylb_without_area.sql