| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Rick James | Date: | April 4 2012 4:18pm |
| Subject: | Re: create multiple tables in a single query | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • create multiple tables in a single query | joe j | 3 Apr |
| • Re: create multiple tables in a single query | hsv | 4 Apr |
| • Re: create multiple tables in a single query | Rick James | 4 Apr |
| • Re: create multiple tables in a single query | Johan De Meersman | 5 Apr |
| • Re: create multiple tables in a single query | Johan De Meersman | 4 Apr |
| • Re: create multiple tables in a single query | joe j | 4 Apr |
| • Re: create multiple tables in a single query | joe j | 4 Apr |
| • Re: create multiple tables in a single query | Johan De Meersman | 5 Apr |
| • Re: create multiple tables in a single query | joe j | 5 Apr |
| • Re: create multiple tables in a single query | joe j | 5 Apr |
| • Re: create multiple tables in a single query | Johan De Meersman | 6 Apr |
| • Re: create more tables in a single query | hsv | 5 Apr |
| • Re: create multiple tables in a single query | Jan Steinman | 5 Apr |
