MySQL - How do I enter NULL?
Stupid question:
In SQL, I know I can do
UPDATE TableA SET MyColumn=NULL
But, how do I enter NULL into a cell graphically? I tried entering 'null' and 'NULL' and '' (nothing/empty string) into the MySQL Query Browser with no success.
- Switch to edit mode
- Right click on field
- Choose "Clear field content"
MySQL Workbench 5.4.42: Terribly buggy, but if you try a couple of times, right-clicking the cell while in Edit mode should give you the option Set Field(s) to NULL.
DEL, Ctrl+0 or similar doesn't work.
In Workbench 6.3 the buggy UI has been fixed. Don't forget to click the Apply button to actually execute the resulting UPDATE statement.