select * into outfile '/home/mysql/xxx.sql' from tb; gzip /home/mysql/xxx.sql
谢谢楼上滴,gzip在sql语句里面报这样的错误select * into outfile 'c:\\a.txt' from tb1;gzip 'c:\\a.txt' ================================================================== Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'gzip 'c:\\a.txt'' at line 1 (0 ms taken)
gzip /home/mysql/xxx.sql
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'gzip 'c:\\a.txt'' at line 1
(0 ms taken)