mysql create table ,store procedure,call sp

?

1

use db;

'CREATE TABLE `t1` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(40) NOT NULL DEFAULT '''',
`author` varchar(40) NOT NULL DEFAULT '''',
`content` varchar(40) NOT NULL DEFAULT '''',
`topic` varchar(40) NOT NULL DEFAULT '''',
`isbn` varchar(40) NOT NULL DEFAULT '''',
`summary` varchar(40) NOT NULL DEFAULT '''',
`title` varchar(40) NOT NULL DEFAULT '''',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32864 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci';

　　

USE `db`;
DROP procedure IF EXISTS `insertLoopT1`;

USE `db`;
DROP procedure IF EXISTS `db`.`insertLoopT1`;
;

DELIMITER $$
USE `db`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `insertLoopT1`()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE (i <= 1000000) DO
    insert into t1(name,author,content,topic,isbn,summary,title) values(uuid(),uuid(),uuid(),uuid(),uuid(),uuid(),uuid());
    SET i = i+1;
END WHILE;
END$$

DELIMITER ;
;

 

call store procedure

call insertLoopT1();