以什么格式导出,就必须以什么格式导入(只包含数据,默认Tab分隔) /* mySql导出(从s_process表导出)(7千万条记录用时2 m 22 s 909 ms,8G) */ SELECT * INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/data.txt' FIELDS TERMINATED BY ',' FROM s_process; /* mySql导入(导入到s_process3表中,7千万条记录用时 34 m 14 s 813 ms) */ LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/data.txt' INTO TABLE s_process3 FIELDS TERMINATED BY ',';
MySql大数据量的导入导出(文本方式)
最新推荐文章于 2024-07-01 11:42:01 发布