-- 建表语句
CREATE TABLE `base_unit_info` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`code` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`note` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 建立mysql函数
DELIMITER $$
USE `wms`$$
DROP PROCEDURE IF EXISTS `autoinsert`$$
CREATE DEFINER=`wms`@`127.0.0.1` PROCEDURE `autoinsert`(IN insertCount INT)
BEGIN
DECLARE count INT DEFAULT 0;
WHILE(count < insertCount)
DO
SET @mySql=CONCAT("INSERT INTO base_unit_info (code, name) VALUES(UUID() ,UUID())");
PREPARE stmt FROM @mySql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET count = count+1;
END WHILE;
END$$
DELIMITER;
-- 调用函数方法
call autoinsert(100000000);
-- 查看条数
select max(id) from base_unit_info;
Mysql autoinsert 自动插入数据
最新推荐文章于 2022-01-06 11:17:29 发布