From: Reindl Harald Date: October 21 2011 8:21am Subject: Re: How to dynamically create database and tables on mysql? List-Archive: http://lists.mysql.com/mysql/226145 Message-Id: <4EA12B77.2060602@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig80E4DA77A3783F4CBD3BEB90" --------------enig80E4DA77A3783F4CBD3BEB90 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Am 21.10.2011 10:05, schrieb =E7=8E=8B=E7=A7=91=E9=80=89: > 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 database create table, drop table create table like..... --------------enig80E4DA77A3783F4CBD3BEB90 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk6hK3cACgkQhmBjz394AnlHdACfXRE1ksN3AvM+HOUfmzEQZqWl xrUAn1iQbNzAWbDuBnb2movfgB+UYRGO =mFJ5 -----END PGP SIGNATURE----- --------------enig80E4DA77A3783F4CBD3BEB90--