----- Original Message ----- > From: "joe j" <joe.st...@gmail.com> > > 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?
You can't create multiple tables with one statement; but you *can* put multiple statements on a single line. However, this does nothing for performance - nor readabiltiy, for that matter :-) You could (on *nix) write a simple commandline loop for it, I suppose. Something along the lines of for x in UK US BE FR; do mysql -e "create table ${x}_table_new as select blahblahblbah"; done -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql