How to create multiple tables using one sql query

Question

I'm going to prepare an installation script for my website which is automatically creates database and it's tables. How can I send every queries in one? Here is the PHP code:

$table_query = "CREATE TABLE IF NOT EXISTS ".TP."_usertypes(
                utid INT(11) NOT NULL AUTO_INCREMENT,PRIMARY KEY (utid),
                utname VARCHAR(255)
                )
                DEFAULT CHARACTER SET utf8
                COLLATE utf8_general_ci;

                CREATE TABLE IF NOT EXISTS ".TP."_users(
                uid INT(11) NOT NULL AUTO_INCREMENT,PRIMARY KEY (uid),
                utid INT(11) NOT NULL,FOREIGN KEY (utid) REFERENCES ".TP."_usertypes(utid) ON DELETE RESTRICT,
                username VARCHAR(255), 
                password VARCHAR(255),
                avatar VARCHAR(255)
                )
                DEFAULT CHARACTER SET utf8
                COLLATE utf8_general_ci";
mysqli_query($connection,$table_query) or die(mysqli_error($connection));

Thank you.

Possible duplicate of Executing multiple SQL queries in one statement with PHP — jitendrapurohit
– jitendrapurohit, Commented Sep 2, 2016 at 11:11
@jitendrapurohit Every topics I saw was about other sql commands not CREATE TABLE. — AmirHussein
– AmirHussein, Commented Sep 2, 2016 at 11:32
@P.Yntema You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS cando_users( uid INT(11) NOT NULL AUTO_INCREMENT' at line 9 — AmirHussein
– AmirHussein, Commented Sep 2, 2016 at 11:34

Tamil · Accepted Answer · 2016-09-02 11:52:03Z

1

With mysqli you're able to use multiple statements for real using mysqli_multi_query().

Read more on multiple statements in the PHP Docs.

answered Sep 2, 2016 at 11:52

Tamil

1,44811 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

O. Jones · Accepted Answer · 2016-09-02 11:11:42Z

0

How can I send every queries in one?

You can't.

You need to send each query in a separate php call.

answered Sep 2, 2016 at 11:11

O. Jones

110k17 gold badges134 silver badges187 bronze badges

Collectives™ on Stack Overflow

How to create multiple tables using one sql query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related