mysql syntax create syntax error cannot find

Asked Feb 13 '22 at 03:35

Active Feb 13 '22 at 03:40

Viewed 11 times

create table if not exists order(
orderID int NOT NULL AUTO_INCREMENT PRIMARY_KEY,
ordertype int, 
productID int,
pname varchar(20),
company varchar(20), 
vari varchar(20), 
price int);

error log:

ERROR 1064 (42000): 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(orderID int NOT NULL AUTO_INCREMENT PRIMARY_KEY,ordertype int, productID i' at line 1

edited Feb 13 '22 at 03:40

Barmar

741,623
53
500
612

asked Feb 13 '22 at 03:35

Abir Ghish

`order` is a reserved word (it's used in `ORDER BY`), you need to quote it with backticks. – Barmar Feb 13 '22 at 03:41
It's the `PRIMARY_KEY`, change it to `PRIMARY KEY`. – ruleboy21 Feb 13 '22 at 03:46
thankyou both it solved my problem – Abir Ghish Feb 13 '22 at 04:33

mysql syntax create syntax error cannot find

0 Answers0