mysqli_multi_query with CREATE TABLE and INSERT INTO

Question

$query = "INSERT INTO abc VALUES ('1', '2', '3')";
$send_to_mysql = mysqli_query($connection, $query);

OK.

$query = "CREATE TABLE abc (a varchar(255), b varchar(255), c varchar(255))";
$send_to_mysql = mysqli_query($connection, $query);

OK.

$query = "CREATE TABLE abc (a varchar(255), b varchar(255), c varchar(255))";
$query .= "INSERT INTO abc VALUES ('1', '2', '3')";
$send_to_mysql = mysqli_multi_query($connection, $query);

nop. Where's the problem?

A missing semicolon separator ?

renick
– renick

2014-04-01 11:56:00 +00:00
Commented Apr 1, 2014 at 11:56 — renick
– renick, Commented Apr 1, 2014 at 11:56
Haha. Can't belive. Thanks!

Kratalin Jan
– Kratalin Jan

2014-04-01 11:58:31 +00:00
Commented Apr 1, 2014 at 11:58 — Kratalin Jan
– Kratalin Jan, Commented Apr 1, 2014 at 11:58

BMN · Accepted Answer · 2014-04-01 11:56:44Z

2

Put a semicolon between your two queries. As you are putting your two queries into one single string, you need to separate them in order for MySQL to understand that you do have two queries :

$query = "CREATE TABLE abc (a varchar(255), b varchar(255), c varchar(255));";
$query .= "INSERT INTO abc VALUES ('1', '2', '3')";

answered Apr 1, 2014 at 11:56

BMN

8,57614 gold badges51 silver badges80 bronze badges

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

Comments

Sadikhasan · Accepted Answer · 2014-04-03 08:29:42Z

0

Put semicolon as separator between two queries like

$query = "CREATE TABLE abc (a varchar(255), b varchar(255), c varchar(255));";
mysqli_multi_query($connection, $query);
$query = "INSERT INTO abc VALUES ('1', '2', '3')";
$send_to_mysql = mysqli_multi_query($connection, $query);

edited Apr 3, 2014 at 8:29

answered Apr 1, 2014 at 11:58

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

Collectives™ on Stack Overflow

mysqli_multi_query with CREATE TABLE and INSERT INTO

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related