[rkhanal]

Hi guys,
I am having a problem here creating a table.
I have a Employee Table which looks like this :-

mysql> SELECT * FROM Employee;
+-------------+----------+
| Employee_ID | Name |
+-------------+----------+
| 1 | Ranjeet |
| 2 | Alax |
| 2 | Kylie |
| 4 | Weiming |
+-------------+-----------+
4 rows in set (0.00 sec)


Now when i am trying to create another Table called " Order" with i am having problem.FYI :-

===>

mysql> CREATE TABLE ORDER
-> (Product_ID INT(10), Product VARCHAR(10), Employee_ID INT(10));

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
(Product_ID INT(10), Product VARCHAR(10), Employee_ID INT(10))' at line 1

===>

Can anyone correct me please. I have used the same syntex before and was working.

regards,
Ran

[healdem]

check the MySQL manual for reserved words..
Im guessing you cannot have a table called Order

[rkhanal]

Originally Posted by healdem

check the MySQL manual for reserved words..
Im guessing you cannot have a table called Order

You are right, Healdem.

I created another table with different name and it works. Thanks for your help.

regards,
Ran