Batch Build MySQL Table

Today, with MySQL's sub-table problem, you can use scripting to iterate through the creation of a new table, or you can build it using SQL. The following is an example of establishing a player_0 to player_9 statement.

Delimiter//CREATE procedure create_table () BEGIN DECLARE ' @i ' int (11); DECLARE ' @sqlstr ' varchar (2560); SET ' @i ' = 0; While the ' @i ' < do SET @sqlstr = CONCAT ("CREATE TABLE player_",

' @i ',

"(' player_id ' int (one) not null auto_increment, ' account_id ' int (one) not null COMMENT ' user ID ', ' personaname ' varchar () NO T NULL COMMENT ' nickname ', PRIMARY KEY (' player_id ')) engine=innodb DEFAULT charset=utf8 comment= ' user table ' Auto_increment=1 '); Prepare stmt from @sqlstr; Execute stmt;
SET ' @i ' = ' @i ' + 1; END while; END; Call Create_table (); drop procedure create_table;