查询表导入到一个文件中,字段结束用单引号间隔,字段用双引号包裹,一条数据结束回车换行
select * from test4 into outfile ‘d:/mysql.sql’ fields terminated by ‘,’
enclosed by ‘"’ lines terminated by ‘\r\n’;
mysql将表中的数据导出到指定的文件中
最新推荐文章于 2024-04-11 10:12:18 发布
查询表导入到一个文件中,字段结束用单引号间隔,字段用双引号包裹,一条数据结束回车换行
select * from test4 into outfile ‘d:/mysql.sql’ fields terminated by ‘,’
enclosed by ‘"’ lines terminated by ‘\r\n’;