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

2011-10-23 Thread Sharl.Jimh.Tsin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2011年10月21日 16:05, 王科选 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

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

2011-10-22 Thread 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

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

2011-10-22 Thread René Fournier
What is your application? Maybe we can help more. On 2011-10-21, at 2: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

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

2011-10-21 Thread Reindl Harald
Am 21.10.2011 10:05, schrieb 王科选: 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! create database, drop

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

2011-10-21 Thread Johan De Meersman
- Original Message - From: Reindl Harald h.rei...@thelounge.net create database, drop database create table, drop table create table like. I suspect the table names and structures are going to be identical each time - I'm thinking automated blog deployment or something.