Bug 155739 - Unable to edit data in a table that contains reserved word as column name
Unable to edit data in a table that contains reserved word as column name
Status: RESOLVED WORKSFORME
Product: db
Classification: Unclassified
Component: MySQL
6.x
All All
: P3 (vote)
: 6.x
Assigned To: Jiri Rechtacek
issues@db
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-12-18 09:17 UTC by guido_ffm
Modified: 2009-10-27 16:04 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description guido_ffm 2008-12-18 09:17:24 UTC
Unable to edit data in a table that contains a column named "key". For MySQL the column names should be escaped with
back quotes "`" to work around this issue.
Comment 1 Jiri Rechtacek 2009-02-10 15:27:03 UTC
Reassigned to new owner.
Comment 2 Jiri Rechtacek 2009-10-27 16:04:43 UTC
It's intentional in MySQL that the reserved words have to be escaped. Anyway, if a table contains such columns it's
possible to edit data there in NB6.8


By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo