Menu

#5 error if table name = reserved word

closed-fixed
nobody
None
5
2009-12-21
2008-04-22
Anonymous
No

Hi,

for example,

select * from order

Error: 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 LIMIT 0,50' at line 1

I think it would be good to use backticks characters for built-in queries, like

select * from `order`

Thank you for good script, greetings from Ukraine :)

Discussion

  • Oleg Savchuk

    Oleg Savchuk - 2009-12-21
    • status: open --> closed-fixed
     
  • Oleg Savchuk

    Oleg Savchuk - 2009-12-21

    fixed in version 1.5.091221 - added table names quoting

     

Log in to post a comment.