CREATE TABLE IF NOT EXISTS `t1` ( `id` int(2) NOT NULL, `name1` varchar(25) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `t1` -- INSERT INTO `t1` (`id`, `name1`) VALUES (1, 'One1'), (2, 'Two1'), (3, 'Three1'); -- -------------------------------------------------------- -- -- Table structure for table `t2` -- CREATE TABLE IF NOT EXISTS `t2` ( `id` int(2) NOT NULL, `name2` varchar(25) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `t2` -- INSERT INTO `t2` (`id`, `name2`) VALUES (1, 'One2'), (2, 'Two2'), (4, 'Four2');