mysql 命令后导入导出数据。删除表

helei 2021-6-20 830 6/20

导入

load data infile '/usr/test1.sql' into table test fields terminated by "," enclosed by '"';



导出


select * from test into outfile '/usr/test1.sql' fields terminated by ',' enclosed by '"';

mysqldump -u root -p   test test>/usr/testtest.sql;

- THE END -

helei

6月20日05:44

最后修改:2021年6月20日
0