MySQL创建存储过程批量插入数据
DROP PROCEDURE IF EXISTS test; CREATE PROCEDURE test() #创建存储函数; BEGIN DECLARE i INT DEFAULT 1; WHILE i < 20 DO INSERT INTO `t_test_auto`(`id`, `name`,`age`) VALUES ('1'+i,'haha',ROUND((7+RAND()*6),2)); SET i = i+1; end WHILE; END; CALL test();#调用存储函数