Trying to create a memory table in mysql through php

Question

I am trying to create a memory table in mysql through php but i keep getting an error:

Error creating database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Order INT)ENGINE = INNODB' at line 1

Below is the code that i am using to try and create it:

$sql = "CREATE TABLE Persons(FirstName CHAR(30),LastName CHAR(30),Age INT, Order INT)ENGINE = MEMORY";
if (mysqli_query($con,$sql))
  {
  echo "Database my_db created successfully";
  }
else
  {
  echo "Error creating database: " . mysqli_error($con);
  }

score 4 · Answer 1 · edited May 23 '17 at 11:50

4

Make sure you are escaping the predefined constants in MySQL like 'order'

$sql = "CREATE TABLE `Persons`(`FirstName` CHAR(30),`LastName` CHAR(30),`Age` INT, `Order` INT)ENGINE = MEMORY";

See this post for more clarification:

Using backticks around field names

edited May 23 '17 at 11:50

Community

1
1

answered Dec 19 '13 at 16:28

L00_Cyph3r

669
4
18

Please mark it as the answer, so people know it's closed. Thnx! – L00_Cyph3r Dec 19 '13 at 16:34

score 1 · Answer 2 · answered Dec 19 '13 at 16:28

1

Order is a reserved word in sql, try replace it with other terminology.

answered Dec 19 '13 at 16:28

Paul Lo

6,032
6
31
36

Trying to create a memory table in mysql through php

2 Answers2