MySQL: 数据的导出
数据的导出
方法1 :图形工具
方法2: SQL语句:
select * from <tablename> into outfile ' ' fields terminated by ' ' lines terminated by '\r\n'
e.g
select * from StuInfo into outfile 'D:/Python/StuInfo.txt' fields terminated by ',' lines terminated by '\r\n';