-- Table structure for table `t1` DROP TABLE IF EXISTS `t1`; CREATE TABLE `t1` ( `ID` int(11) NOT NULL default '0', `Population` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `Population` (`Population`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `t1` VALUES(1,1); INSERT INTO `t1` VALUES(2,1); INSERT INTO `t1` VALUES(3,1); INSERT INTO `t1` VALUES(4,1); INSERT INTO `t1` VALUES(5,1); INSERT INTO `t1` VALUES(6,1); INSERT INTO `t1` VALUES(7,1); INSERT INTO `t1` VALUES(8,1); INSERT INTO `t1` VALUES(9,1); INSERT INTO `t1` VALUES(10,1); -- Table structure for table `t2` DROP TABLE IF EXISTS `t2`; CREATE TABLE `t2` ( `ID` int(11) NOT NULL default '0', `Population` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `Population` (`Population`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `t2` VALUES(1,2); INSERT INTO `t2` VALUES(2,2); INSERT INTO `t2` VALUES(3,2); INSERT INTO `t2` VALUES(4,2); INSERT INTO `t2` VALUES(5,2); INSERT INTO `t2` VALUES(6,2); INSERT INTO `t2` VALUES(7,2); INSERT INTO `t2` VALUES(8,2); INSERT INTO `t2` VALUES(9,2); INSERT INTO `t2` VALUES(10,2); -- Table structure for table `t0` DROP TABLE IF EXISTS `t0`; CREATE TABLE `t0` ( `ID` int(11) NOT NULL default '0', `Population` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `Population` (`Population`) ) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`t1`,`t2`); /* ALTER TABLE `t1` DISABLE KEYS; TRUNCATE TABLE `t1`; INSERT INTO `t1` VALUES(1,1); INSERT INTO `t1` VALUES(2,1); INSERT INTO `t1` VALUES(3,1); INSERT INTO `t1` VALUES(4,1); INSERT INTO `t1` VALUES(5,1); INSERT INTO `t1` VALUES(6,1); INSERT INTO `t1` VALUES(7,1); INSERT INTO `t1` VALUES(8,1); INSERT INTO `t1` VALUES(9,1); INSERT INTO `t1` VALUES(10,1); ALTER TABLE `t1` ENABLE KEYS; /*