建表语句:
CREATE TABLE `t_user` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`bu_id` INT(20) NOT NULL,
`name` VARCHAR(255) NOT NULL,
`age` INT(11) NOT NULL,
`sex` VARCHAR(255) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `index_uid_name_age` (`bu_id`, `name`, `age`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=22014
;
批量插入数据:
CREATE PROCEDURE batch_insert()
BEGIN
DECLARE a INT DEFAULT 1;
WHILE (a <= 10000) DO
SET a = a + 1;
insert into t_user set name='name2', age=a, bu_id=a+5;
END WHILE;
COMMIT;
END;
CALL batch_insert();
**Explain SQL: **