#!/bin/bash

mysql test -e "DROP TABLE IF EXISTS t1;CREATE TABLE t1 (id int(10) unsigned NOT NULL AUTO_INCREMENT, a int(11) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB;"
mysql test -e "INSERT INTO t1 (a) values (1),(2),(3),(4),(5);"
mysql test -e "set @a=1;INSERT INTO t1 (a) SELECT (@a:=@a+1) FROM t1, t1 t2, t1 t3, t1 t4, t1 t5, t1 t6, t1 t7;"

for i in {2..200} ; 
  do 
    mysql test -e"DROP table IF EXISTS t$i;CREATE TABLE t$i LIKE t1; INSERT INTO t$i SELECT * from t1" 
    mysql test -e"TRUNCATE t$i;"
    #mysql test -e"DROP TABLE t$i" ;
done