mysql存储过程(瞬间插入几百万条数据)
2017-04-05
后端
DELIMITER $$
USE `goods`$$
DROP PROCEDURE IF EXISTS `add_goods`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `add_goods`(IN `num` INT)
BEGIN
DECLARE xid INT;
SET xid = num;
WHILE xid > 0 DO
INSERT INTO `goods_test` (`gid`,`title`) VALUES (NULL,CONCAT('aaaaaaaaaa',xid));
SET xid = xid - 1;
END WHILE;
END$$