Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    22

    Unanswered: Hi all please help

    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

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    check the MySQL manual for reserved words..
    Im guessing you cannot have a table called Order

  3. #3
    Join Date
    Mar 2008
    Posts
    22
    Quote 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •