DELIMITER $$ DROP PROCEDURE IF EXISTS testproc CREATE PROCEDURE testproc() BEGIN ---不应该这样定义变量int$$ declare i int while i<6 do insert into test values(uuid(),''); set i=i+1 end while END$$ DELIMITER ;
误解了DELIMITER $$的意思 正确代码如下 DELIMITER $$DROP PROCEDURE IF EXISTS `test`.`testproc`$$CREATE PROCEDURE `testproc`() BEGIN declare i int; set i=0; while i<6 do insert into test(id) values(uuid()); set i=i+1; end while; END$$DELIMITER ;
DROP PROCEDURE IF EXISTS testproc
CREATE PROCEDURE testproc()
BEGIN
---不应该这样定义变量int$$
declare i int
while i<6 do
insert into test values(uuid(),'');
set i=i+1
end while
END$$
DELIMITER ;
DELIMITER $$DROP PROCEDURE IF EXISTS `test`.`testproc`$$CREATE PROCEDURE `testproc`()
BEGIN
declare i int;
set i=0;
while i<6 do
insert into test(id) values(uuid());
set i=i+1;
end while;
END$$DELIMITER ;