注意点:sql脚本文件最好经过排序处理,这样效率会快很多
load data local infile '/root/测试.sql' into table `test` fields terminated by ',' lines terminated by '\n';
注意点:sql脚本文件最好经过排序处理,这样效率会快很多
load data local infile '/root/测试.sql' into table `test` fields terminated by ',' lines terminated by '\n';