当前位置:Gxlcms > mysql > mysql存储过程运行成功,但是callprocedure的时候却报错

mysql存储过程运行成功,但是callprocedure的时候却报错

时间:2021-07-01 10:21:17 帮助过:74人阅读

mysql存储过程

BEGIN
DECLARE i INT;
SET i = 18672700000;

WHILE i < num DO
INSERT INTO userinfo (
Uid,
Utype,
Tmac,
ACname,
SSID,
UTip,
UTtype,
ULtime,
UOtime,
POname,
Portal,
Appid
)
VALUES
(
i,
'普通用户',
'0C-37-DC-804',
'0020000000',
'wanglangwifi',
'192.168.0.1',
'IPHONE6',
FROM_UNIXTIME(UNIX_TIMESTAMP('20100101000000') + ROUND(RAND() * (UNIX_TIMESTAMP() - UNIX_TIMESTAMP('20100101000000')))),
FLOOR(RAND() * 100 + 1),
'默认组织机构',
'10.0.13.2',
FLOOR(RAND() * 757 + 1)
);
SET i = i + 1;
END WHILE;
END

call procedure wanglang5(18672796110);显示如下错误
[SQL]CALL PROCEDURE wanglang5(18672796110)

[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 'PROCEDURE wanglang5(18672796110)' at line 1

人气教程排行