MySQL Bugs: #2430: no [apparent] way to set field value to [NULL] using the GUI

Bug #2430	no [apparent] way to set field value to [NULL] using the GUI
Submitted:	16 Jan 2004 10:23	Modified:	16 Jan 2004 10:42
Reporter:	Justin Watt	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQLCC	Severity:	S3 (Non-critical)
Version:	0.9.4-beta	OS:	Windows (Windows 2000)
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:
There appears to be no way to set a field value to [NULL] using the "Query Window" GUI.

How to repeat:
1) Enter text into field
2) Delete text from field
(field remains blank, is set to "")
3) Typing "[NULL]" into field actually sets the field to the string "[NULL]", not the [NULL] value

Suggested fix:
Create a button, keyboard combination, and context menu option for setting a field value to [NULL]. 

The best keyboard option to set a field to [NULL] would be the use of the delete key when the field has focus. Currently, this triggers the database to ask if the row should be deleted, (see bug 2429) which should not occur. Setting the field to [NULL] would be a better option (with escape remaining as an undo option).

You should be able to do this with CTRL-0.

After I figured out you meant Ctrl-zero, not Ctrl-oh, it worked. Sort of. 

Caveat: you have to be editing the field. If you only have focus of the field, the system will enter a zero.

Still seems like there should be a more obvious UI widget... or documentation? Is there any mysqlcc documentation anywhere?