Bug #11908 Column name with reserved word, failed when inserting
Submitted: 13 Jul 2005 11:11 Modified: 13 Aug 2005 11:45
Reporter: Alan Cui Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.19 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[13 Jul 2005 11:11] Alan Cui
Description:
I create a table with a column named `interval`.
When I inserted data, an error occured.
I found the statement it use is like "INSERT INTO TABLE_NAME(...,interval,...)....".
Although using a reserved word as a column name is not encouraged, the error is avoided in many systems such as phpMySqlAdmin.

How to repeat:
whenever

Suggested fix:
add "`" before and after a column name.
[13 Jul 2005 11:45] Aleksey Kishkin
Hi!
I tested it against last query browser (1.1.13) and was able to create table and insert values into field interval.

Could you check if newest query browser on your computer works well?
[13 Aug 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".