18),('root','root',18),('cat','cat',17),('dog','dog',15),('dog1','dog1',15),('zhu','zhu',21);
-- 表数据导出...INTO OUTFILE 'F:/user1.txt'
Fields TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';
-- 表数据导入...DATA INFILE 'F:/user.txt' INTO TABLE user;
select * from user;
-- 导入有特殊格式的表user1.txt(去除分隔号','和字串的引号...TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';
select * from user;
=================
三 txt文件查看
-- 表数据导出...admin",18
"root","root",18
"cat","cat",17
"dog","dog",15
"dog1","dog1",15
"zhu","zhu",21
----
结语：数据的具体导入导出格式大家可以自己尝试一下
