From: Johan De Meersman Date: April 5 2012 8:38am Subject: Re: create multiple tables in a single query List-Archive: http://lists.mysql.com/mysql/227119 Message-Id: <3baffb60-805b-49a8-a76b-4fd8205257c9@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Rick James" > > That sounds like the wrong way to design the schema. Why not have > `country` as a column in a single table? Given that he got all the data for the new tables from existing ones, I was assuming he needed separate tables for some specific purpose - exports, performance, whatnot. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel