1 drop procedure IF EXISTS create_table;
 2 
 3 DELIMITER //
 4 CREATE procedure create_table()
 5 BEGIN
 6 
 7 
 8 SET @i=0;
 9 WHILE @i < 10 DO
10     SET @sqlstr = CONCAT(
11     "CREATE TABLE `test-user`.teacher_",
12     @i,
13     "(
14     `id` bigint(21) NOT NULL AUTO_INCREMENT,
15     `number` int(11) NOT NULL ,
16     `name` varchar(50) DEFAULT NULL,
17     `phone` bigint(17) DEFAULT NULL,
18     `address` varchar(255) DEFAULT NULL,
19     `card` varchar(255) DEFAULT NULL,
20     PRIMARY KEY (`id`)
21     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1; ");
22 
23     prepare stmt from @sqlstr;
24     execute stmt;
25 
26     SET @i = @i + 1;
27 END WHILE;
28 END;
29 //
30 DELIMITER ;
31 call create_table();
32 drop procedure create_table;