mysql delimiter 存储过程

为什么80%的码农都做不了架构师？>>>   

命令行登录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);

转载于:https://my.oschina.net/sbcagf/blog/782995