File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes About the name of table in mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "About the name of table in mysql " Watch "About the name of table in mysql " New topic

About the name of table in mysql

swenling wen
Ranch Hand

Joined: Jun 07, 2006
Posts: 32
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
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
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.

Consultant, Sima Solutions
I agree. Here's the link:
subject: About the name of table in mysql
It's not a secret anymore!