delimiter //
DECLARE num INT;
SET num=0;
WHILE num<1000 DO
INSERT INTO aaa VALUES(NULL,num);
SET num=num+1;
END WHILE;
//
delimiter ;
報錯：
[SQL]
DECLARE num INT;
SET num=0;
WHILE num<1000 DO
INSERT INTO aaa VALUES(NULL,num);
SET num=num+1;
END WHILE;
;
[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 num INT;
SET num=0;
WHILE num<1000 DO
INSERT INTO aaa VALUES(NULL,nu' at line 1
uj5u.com熱心網友回復：
從自己的經驗看，是的uj5u.com熱心網友回復：
截止目前的版本是這樣的轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/105071.html
標籤：MySQL