About the name of table in mysql

[swenling wen]

last time,my project manager give me a table named "order" ,this table is in mysql. I know order is a key word, there is a error when writing sql statement ,how to solve it except changing the the name of the table.
thank you!

[Merrill Higginson]

You might try putting quotes around it like this:

select * from "order"

This would work for the Microsoft flavor of SQL, but I'm not sure about the MYSQL flavor. If this doesn't work, I don't see any other alternative except renaming the table.