Mysql error code creating table

Question

create table Order (ord_no int, purch_amt int check(purch_amt < 50), customer_id varchar(30), salesman_id varchar(30), Primary Key (ord_no));

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 (ord_no int, purch_amt int check(purch_amt < 50), customer_id varchar(30),' at line 1

score 2 · Accepted Answer · edited May 23 '17 at 12:33

2

order is a reserved word in MySQL. Use some other name.

See this related post: Syntax error due to using a reserved word as a table or column name in MySQL

I think you can use back-ticks to quote your table name, but I think that is not a great idea.

edited May 23 '17 at 12:33

Community

1
1

answered Jan 18 '17 at 05:31

codeforester

39,467
16
112
140

thanks... it worked – Jan 18 '17 at 05:34

Mysql error code creating table

1 Answers1