尝试过用存储过程:
但这个存储过程是不是错的,错在哪?
有没有其它的办法循插入数据.??CREATE PROCEDURE pp()
BEGIN
declare int v;
set v=0;
while v<5 do
insert into t_RndPwd(RndPwd_PhoneNo,RndPwd_Message,RndPwd_Time) VALUES('22222222222','mm','2007-10-24');
SET v=v+1;
END while;
END;
但这个存储过程是不是错的,错在哪?
有没有其它的办法循插入数据.??CREATE PROCEDURE pp()
BEGIN
declare int v;
set v=0;
while v<5 do
insert into t_RndPwd(RndPwd_PhoneNo,RndPwd_Message,RndPwd_Time) VALUES('22222222222','mm','2007-10-24');
SET v=v+1;
END while;
END;
delimiter ||
CREATE PROCEDURE pp()
BEGIN
declare v int;
set v=0;
while v <5 do
insert into t_RndPwd(RndPwd_PhoneNo,RndPwd_Message,RndPwd_Time) VALUES( '22222222222 ', 'mm ', '2007-10-24 ');
SET v=v+1;
END while;
END||
delimiter ;
http://blog.chinaunix.net/u/29134/showart_400939.html