导出数据:
1.创建一个目录,如:/2018,修改目录属主为mysql:mysql
2.select * from zty1.STUDENT INTO OUTFILE '/2018/1.txt' fields terminated by ',' lines terminated by '\n';
导入数据
load data local infile '/root/mysql.txt' into table zty1.loaddata fields terminated by ',' lines terminated by '\n';
1.创建一个目录,如:/2018,修改目录属主为mysql:mysql
2.select * from zty1.STUDENT INTO OUTFILE '/2018/1.txt' fields terminated by ',' lines terminated by '\n';
导入数据
load data local infile '/root/mysql.txt' into table zty1.loaddata fields terminated by ',' lines terminated by '\n';