[SQL]
DECLARE @kk INT;
[Err] 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 'DECLARE @kk INT' at line 1
请高手请教~作者: caiw0418 时间: 2011-1-11 15:29
use DM;
DECLARE @kk INT;
SET @kk = 1000;
WHILE @kk <= 2000
BEGIN
insert into TaskExecution(TaskID,WorkerID,Data,IP,Type,WorkerPrice,IsPaid) VALUES(@kk,@kk,'quantitative','192.168.0.1',1,1,0);
SET @kk=@kk+1;
END//作者: caiw0418 时间: 2011-1-11 15:29
上面是我写的数据库函数作者: ppaxxl 时间: 2011-1-11 16:05
没看出来