How to make a field NULL using MySQL GUI Tools?

Question

I'm using the MySQL Query Browser (part of the MySQL GUI Tools) and need to change a field to NULL, but I can't figure out how to do it - if I delete the value it tries to update it to ''. Typing "NULL" makes it try to update to 'NULL' (a string).

I know I could just write a query to do it, but that defeats the entire purpose of the tool, no?

Answer 1

I'd try Ctrl-0 (zero), because that works in some tools.

Answer 2

Right click on the cell and select 'Clear field content'

Answer 3

Removing the contents:

This works for some tools (sorry to hear it doesn't for yours). This may not appear as null but will when you perform a query.