2.导出数据表txt文件到指定目录:select * from table_name into outfile '指定目录';
3.加载指定文件到数据表中:load data local infile '文件路径' into table table_name;
2.导出数据表txt文件到指定目录:select * from table_name into outfile '指定目录';
3.加载指定文件到数据表中:load data local infile '文件路径' into table table_name;