DROP PROCEDURE IF EXISTS proc_initData;
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=9900 DO
INSERT INTO people(name,address) VALUES(“zh”,“包头”);
SET i = i+1;
END WHILE;
END $
CALL proc_initData();
DROP PROCEDURE IF EXISTS proc_initData;
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=9900 DO
INSERT INTO people(name,address) VALUES(“zh”,“包头”);
SET i = i+1;
END WHILE;
END $
CALL proc_initData();