56,677
社区成员
发帖
与我相关
我的任务
分享
create procedure sp_name()
begin
end
create procedure sp_name()
begin
insert into test values(3,3)
end
DELIMITER $$
CREATE
PROCEDURE `sp_doit`()
BEGIN
DECLARE i INT; --Changed by ACMAIN
SET i=1;
WHILE i<100000 DO
INSERT INTO test VALUES(6,66);
SET i=i+1;
END WHILE;
END
$$
DELIMITER ;
mysql> CREATE
-> PROCEDURE `sp_doit`()
-> BEGIN
-> DECLARE i INT;
-> SET i=1;
-> WHILE i<100000 DO
-> INSERT INTO test VALUES(6,66);
-> SET i=i+1;
-> END WHILE;
-> END
-> $$
Query OK, 0 rows affected (0.00 sec)
DELIMITER $$
CREATE
PROCEDURE `study`.`sp_doit`()
BEGIN
INSERT INTO test VALUES(6,66);#原来的没加分号,加上就可以了
END
$$
DELIMITER ;
DELIMITER $$
CREATE
PROCEDURE `study`.`sp_doit`()
BEGIN
DECLARE i;
SET i=1;
WHILE i<100000 DO
INSERT INTO test VALUES(6,66);
SET i=i+1;
END WHILE;
END
$$
DELIMITER ;
DELIMITER $$
CREATE
PROCEDURE `study`.`sp_test`()
BEGIN
SELECT * FROM test
END$$
DELIMITER ;