From: Rick James Date: April 4 2012 4:18pm Subject: Re: create multiple tables in a single query List-Archive: http://lists.mysql.com/mysql/227114 Message-Id: <4F7C7463.1050602@yahoo-inc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit That sounds like the wrong way to design the schema. Why not have `country` as a column in a single table? On 4/3/12 6:22 PM, Hal?sz S?ndor wrote: >>>>> 2012/04/03 22:27 +0200, joe j>>>> > So what I am trying to get is a script that runs through a list of > country names (US, UK, NL, etc) and create tables for each one of them > as above. Is this feasible in MySql? > <<<<<<<< > There are PROCEDUREs, and there is PREPARE. Look them up. > > -- Rick James - MySQL Geek