事件定时运行 SET @jb = CONCAT('SELECT * into outfile','e:\\computer',var,'.txt', ' from tseccom limit ',var2,',5'); prepare stml from @jb; execute stml;
用mysqldump导 写crontab来定时
补充一下 是 windows 操作系统
Procedure execution failed 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 'e:\computer0.txt from tseccom limit 0,5' at line 1
SET @jb = CONCAT('SELECT * into outfile','e:\\computer',var,'.txt', ' from tseccom limit ',var2,',5');
prepare stml from @jb;
execute stml;
写crontab来定时
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 'e:\computer0.txt from tseccom limit 0,5' at line 1