简单的mysql导出和导入数据

SELECT * FROM mytable LIMIT 0,100 INTO OUTFILE '/tmp/test.txt';
LOAD DATA INFILE '/tmp/test.txt' INTO TABLE mytable;

posted on 2020-08-06 17:55  会走路的虾米  阅读(82)  评论(0编辑  收藏  举报

导航