doudui1850 2015-05-06 05:53
浏览 533
已采纳

MySQL错误1064:SELECT语句中的SQL语法错误

I am relatively new to somewhat advanced MySQL querying. I had been trying to query the most recent order in an order table of a particular user using MySQL SELECT statement using the following MySQL query.

SELECT o1.* FROM order AS o1
WHERE o1.orderDateTime = 
( 
  SELECT MAX(o2.orderDateTime) FROM order AS o2
  WHERE o2.userId = '1'
) 

But I had been constantly getting the following MySQL error #1064 related to MySQL syntax.

#1064 - 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 AS o1 WHERE o1.orderDateTime = (SELECT MAX(o2.orderDateTime)FROM order AS ' at line 1

I got similar errors in relation with INSERT statements but I managed to fix it up using the methods specified in MySQL 1064: You have an error in your SQL syntax I made every effort to fix the query in the current case but I was still unsuccessful.

I would be grateful to you if someone can help me out with fixing this MySQL syntax error for SELECT clause specified above. It would be great if someone could specify me the exact reason for the occurrence of this issue, as well.

  • 写回答

3条回答 默认 最新

  • douqiao4450 2015-05-06 05:54
    关注

    order is a reserved word and its a bad choice for table name. You need to escape using backticks in the query

    SELECT o1.* FROM `order` AS o1
    WHERE o1.orderDateTime = (
        SELECT MAX(o2.orderDateTime) FROM `order` AS o2
        WHERE o2.userId = '1'
    ) 
    

    http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?