This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 155739

Summary:	Unable to edit data in a table that contains reserved word as column name
Product:	db	Reporter:	guido_ffm <guido_ffm>
Component:	MySQL	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED WORKSFORME
Severity:	blocker	CC:	romanmostyka
Priority:	P3
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:

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