Mysql常用命令

导出命令

select * from b10 into outfile 'd:/b10.txt';

GBK格式导入 默认TAB分割

load data infile 'D:/test.txt' ignore into table b_1 character set gbk lines terminated by '\n'(user,conn);

load data infile 'D:/test.txt' ignore into table b_1 lines terminated by '\n'(user,conn);