If you are working on a project that force you to create multiple tables in one statement with MySQL & PHP because it is more efficient with your web server, you can try this code out:
PHP Code for Making Multiple Tables
1 2 3 4 5 6 7 8 | <?php $qry = " CREATE TABLE tablename(fieldname fieldproperties) TABLE TYPE; CREATE TABLE tablename2(fieldname fieldproperties) TABLE TYPE; CREATE TABLE tablename3(fieldname fieldproperties) TABLE TYPE; CREATE TABLE tablename4(fieldname fieldproperties) TABLE TYPE; "; ?> |
It creates a statement that includes many CREATE TABLE statement, this will be executed in batch by MySQL. Just connect to MySQL, select database in your server and execute this query. Hope it helps.
Posts Related to How to Create Multiple Tables in One Statement with MySQL & PHP:
- Insert Into Select PHP
INSERT INTO SELECT php statement is used to insert new... - Portable XAMPP
Portable XAMPP is quite easy to setup and install. XAMPP... - Create Hidden Partitions with Secret Disk
Secret Disk is a free tiny tool you can download... - PuTTY Tutorial SSH
PuTTY Tutorial SSH is intended for a beginner using PuTTY... - Lenovo Coupon Code IdeaPad Y530
This Lenovo Coupon Code can be applied to buy IdeaPad... - How To Install OS X from Disk Image on Lenovo IdeaPad S10
Read step by step on how to install OS X... - Setup Vista Drivers on Windows 7
Just for your information, Vista drivers may work on Windows... - Dell Studio 15 Coupon Code – 25% Off
This coupon code can be applied to Dell Studio 15,... - Verbatim Gigabit NAS External Hard Drive
Verbatim has released their new external hard drive, Verbatim Gigabit... - Lenovo ThinkServer TS200v – Under $500 Reliable Server
Lenovo has released their new cheapest server, Lenovo ThinkServer TS200v....
