On 10/21/2011 3:05 AM, 王科选 wrote:
Hi,
Is there any way to dynamically create database and tables on mysql?
For example, if I want to create 100 databases(dbname is unknown until run time), with 100 predefined tables in it, how to achieve that?
Thanks in advance!

Easiest mebbe from a scripting language like Perl or PHP, but you could also do it with PREPARE in a MySQL stored procedure.

PB

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to