mysql循环
-- DROP PROCEDURE test_insert
DELIMITER ;;
CREATE PROCEDURE test_insert ()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<500
DO
insert into areainfo VALUES (i,"province","city","area"
原创
2018-11-13 23:31:10 ·
160 阅读 ·
0 评论