OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: create multiple tables in a single query

From: joe j (joe.statagmail.com)
Date: Thu Apr 05 2012 - 14:36:06 CDT


>Jan Steinman wrote
>If not, how 'bout the best of both worlds: create a UNIX (or perl) script that loops
>through the country names and creates an SQL script? That would be fast entering AND fast
>performing!

Good suggestion. But I am a perl/unix illiterate. However I may learn
in them future-you never know!

>hsv wrote
>I yet suggest that you write an SQL procedure with a constructed string passed to PREPARE.

If the shell command works- I'll try that on a new set of tables
soon-then I'd stick with that because I use mysql only sparingly so
don't know advanced techniques. But I'll keep this in mind, just in
case.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql