BEGINDECLAREiINT; SETi18672700000; WHILEi <numDOINSERTINTOuserinfo (Uid, Utype, Tmac, ACname, SSID, UTip, UTtype, ULtime, UOtime, POname, Portal, Appid) VALUES (I, & #39; common user & #39;, & #39; 0C-37-DC-804 & #39;, & #39; 0020000000 & #39;, & #39; mysql stored procedure
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,
'Common user ',
'0c-37-DC-804 ',
'123 ',
'Wanglangwifi ',
'1970. 168.0.1 ',
'Iphone6 ',
FROM_UNIXTIME (UNIX_TIMESTAMP ('000000') + ROUND (RAND () * (UNIX_TIMESTAMP ()-UNIX_TIMESTAMP ('000000 ')))),
FLOOR (RAND () * 100 + 1 ),
'Default organizational unit ',
'10. 0.13.2 ',
FLOOR (RAND () * 757 + 1)
);
SET I = I + 1;
End while;
END
Call procedure wanglang5 (18672796110); the following error is displayed:
[SQL] CALL PROCEDURE wanglang5 (0, 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