<?
$server = "localhost";
$user = "";
$passwd = "";
$tablemax = 256;
$recnum = 50;
$database = "mergetest";
$conn = mysql_connect($server,$user,$passwd);
$query = "drop database if exists ".$database;
$result = mysql_query($query);
$query = "create database ".$database;
$result = mysql_query($query);
$selected = mysql_select_db($database,$conn);
$unionstr = "";
for ($i=0;$i<$tablemax;$i++){
	 $tname = "T".$i;
	 $query = "create table ".$tname." (a int(3), b int(4), c int(4)) TYPE=MYISAM";
     $result = mysql_query($query);
     for ($j=0;$j<$recnum;$j++){
	 	$query = "insert into ".$tname." values(".rand(0,100).", ".rand(0,1000).",".rand(0,1000).")";
     	$result = mysql_query($query);
     }
	 $unionstr.= $tname.",";
}
$unionstr = substr($unionstr, 0, -1);     // Take off last comma
$query = "create table tmerge (a int(3), b int(4), c int(4)) TYPE=MERGE UNION=(".$unionstr.")";
$result = mysql_query($query);
 

?>