MySql使用存储过程插入数据
代码
DROP PROCEDURE IF EXISTS proc_initData;
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 20000;
WHILE i<=10000 DO
INSERT INTO contact VALUES(i,FLOOR (RAND(1)),转载：https://blog.csdn.net/qq_38431303/article/details/102059737
查看评论