Re: How to dynamically create database and tables on mysql?

[Peter Brawley]

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