create table table_names (

  id int primary key auto_increment,

  name varchar(255)

) engine=innodb;

insert into table_names values (1, 't1');

let $counter = 1;

while ($counter <= 10000) {

  let $id = `select max(id) + 1 from table_names`;

  eval

  insert into table_names (name) values (concat('t', convert($id, char)));

  inc $counter;

}

let $data_size = `select count(*) from table_names`;

let $counter = 1;

while ($counter <= $data_size) {

  let $table_name = `select name from table_names where id = $counter`;

  eval

  create table $table_name (i int) engine=innodb;

  eval

  insert into $table_name values (1), (2), (3), (4), (5);

  inc $counter;

}

let $counter = 1;

while ($counter <= $data_size) {

  let $table_name = `select name from table_names where id = $counter`;

  eval

  update $table_name set i = i + 1;

  inc $counter;

}

let $counter = 1;

while ($counter <= $data_size) {

  let $table_name = `select name from table_names where id = $counter`;

  eval

  drop table $table_name;

  inc $counter;

}

drop table table_names;

2.9.1 Thread-Safety

All functions defined by this volume of IEEE Std 1003.1-2001 shall be thread-safe, except that the following functions1 need not be thread-safe.