MySQL Query Browser How do I enter NULL ?

Question

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.

Answer 1

Google returned:

You can right-click on a cell and choose "Clear Field Content" in the popup menu. It will set the cell value to NULL.

Answer 2

1.Switch to edit mode 2.Right click on field 3. Choose "Clear field content"

Answer 3

Has been the field type declared as char?