mysql delimiter 存储过程

命令行登录mysql
cd /d D:\database\mysql1\bin
mysql.exe -P 3306 -h 127.0.0.1 -u root -p

USE tbschedule
delimiter //
CREATE PROCEDURE CREATE_TEST_DATA(IN ownSign varchar(50),IN datanum INTEGER(11))
BEGIN
declare i int DEFAULT 1;
WHILE i <= datanum DO
insert into SCHEDULE_TEST VALUES(i,0,'N',ownSign);
set i = i + 1;
END WHILE;
END;
//

delimiter ;
CALL CREATE_TEST_DATA('BASE',300000);

posted @ 2016-11-01 10:38  穿林度水  阅读(1431)  评论(0编辑  收藏  举报