导出 CSV:
进入msyql;
运行: show variables like ‘%secure%’;
看文件导入路径:secure_file_priv 假设为E:\testMysql\test.csv
#参考:https://www.jb51.net/article/125903.htm
调用 select * from daily_report info into outfile ‘E:\testMysql\test2.csv’ fields terminated by ‘,’ optionally enclosed by ‘"’ escaped by ‘"’ lines terminated by ‘\r\n’;
其中E:\testMysql\test2.csv为上文查看的导出路径。
导出CSV格式;
博客原文:
https://www.cnblogs.com/SZxiaochun/p/6027450.html
https://blog.csdn.net/k346k346/article/details/51887599
如果路径不对报错,或者想调整导出路径,查看:
https://www.jb51.net/article/125905.htm
https://blog.csdn.net/h12kjgj/article/details/77187304
MYSQL重启,可见:
https://www.jb51.net/article/125901.htm
mysql 查看表结构:
https://www.cnblogs.com/zhangyuhang3/p/6873895.html
导出sql:
运行:mysqldump -uroot -pmysql 库名 表名 > e:\date_drv.sql
博客:
https://blog.csdn.net/dm1314oooooooo/article/details/72818559