ningziwen的博客

mysql批量插入存储函数 DROP PROCEDURE test_insert ; DELIMITER $$ CREATE PROCEDURE test_insert() BEGIN DECLARE v_deviceid VARCHAR(2000) DEFAULT ''; DECLARE i tinyint DEFAULT '1'; WHILE i<99999 DO SET v_deviceid = round(round(rand(),4)*10000); INSERT INTO `de