SELECT mobile,password FROM t_yonghu INTO OUTFILE '/usr/local/sys_user_yun.csv' FIELDS TERMINATED BY ',';
按照逗号的分隔符进行字段分割
2、使用 mysqldump导出某个表的整个表结构和数据
mysqldump -uroot -pwukong123 wo_ips t_news_info > /usr/local/t_news_info.sql
mysql的几种数据导入导出总结
SELECT mobile,password FROM t_yonghu INTO OUTFILE '/usr/local/sys_user_yun.csv' FIELDS TERMINATED BY ',';
按照逗号的分隔符进行字段分割
2、使用 mysqldump导出某个表的整个表结构和数据
mysqldump -uroot -pwukong123 wo_ips t_news_info > /usr/local/t_news_info.sql