syntax error primary key during creating table after primary key

Asked Feb 18 '19 at 14:26

Active Feb 18 '19 at 15:42

Viewed 22 times

error in first line code during creating a table in MySQL I created a table but there is an exception: 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 'order ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, mod' at line 1

    $newTable = "CREATE TABLE order (
        id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
            modelname VARCHAR(300),
            price INT(6),
            client VARCHAR(300),
            address VARCHAR(300),
 reg_date TIMESTAMP
    )";
$conn->query($newTable);

edited Feb 18 '19 at 15:42

Sayed Mohd Ali

2,156
3
12
28

asked Feb 18 '19 at 14:26

androidev

You need to escape reserved words like order with backticks – B001ᛦ Feb 18 '19 at 14:28
order is reserved ? – androidev Feb 18 '19 at 14:29
1

_order is reserved ?..._ yes it is .. order by.. you have definitely heared of it – B001ᛦ Feb 18 '19 at 14:29
See https://mariadb.com/kb/en/library/reserved-words/ for the full list – Jonas D. Feb 18 '19 at 14:30
1

Thanks ! I changed word and it works – androidev Feb 18 '19 at 15:09

syntax error primary key during creating table after primary key

0 Answers0