This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "About the name of table in mysql " Watch "About the name of table in mysql " New topic
Author

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.


Merrill
Consultant, Sima Solutions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: About the name of table in mysql
 
Similar Threads
how to get top 5 result from database
Problem with many-to-many relationships with MySQL
RegEx for valid mysql table name
How to uplaod excel data into mysql data base in struts..?
how to select 2nd,3rd or the Nth highest salary from a table in desc or ascen order?