Outfile :
语法:
Select * into outfile ‘文件路径+文件名’ from tbl_name;
Select * into outfile 'c: /users/administrator/desktop/MySQL/one' from j_teacher;
//路径有问题
分割方式:
Fields:
设置字段选项,
Lines:
设置行选项,
Select * into outfile 'C:\ProgramData\MySQL\MySQL Server 5.5\data'
Fields terminated by ’,’ enclosed by ‘x’ lines terminated by ‘\n’ starting by ‘start:’ from j_teacher;
二进制数据:
使用dumpfile