A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
About the name of table in mysql
Joined: Jun 07, 2006
Jun 09, 2006 01:27:00
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.
Joined: Feb 15, 2005
Jun 09, 2006 11:28:00
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.
I agree. Here's the link:
subject: About the name of table in mysql
Problem with many-to-many relationships with MySQL
how to get top 5 result from database
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?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015