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