How to set a field to NULL in MySQL Query Browser?

Question

I just decided to replace phpMyAdmin by Mysql Query Browser ( finally I can have tabs!! ), but I'm having a really stupid problem.
I need to set a field value to NULL instead of empty string: if I simply delete the content of the field, it will be set to empty string...

Of course, I don't want to do it through a query, I just want to use the visual editor.

Thank you

Manse · Accepted Answer · 2012-03-30 08:29:51Z

3

Right click on the cell while not in edit mode and click "Clear field content"

answered Mar 30, 2012 at 8:29

Manse

38.1k11 gold badges88 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

haltabush Over a year ago

That's almost it: if I'm currently editing the field, I can't do it. But if I right click on the cell while NOT editing it, it works. That's a bit weird, and it's the reason why I couldn't find it directly :)

user671253 · Accepted Answer · 2012-03-30 08:31:07Z

2

Switch to edit mode
Right click on field
Choose "Clear field content"

answered Mar 30, 2012 at 8:31

user671253

Comments

Baba · Accepted Answer · 2013-04-26 10:06:36Z

0

Right Click - > Edit Table Data
Right Click ON Field
Set Field(s) to NULL ( version 5.2.38 CE )

Or

Just Type NULL
And Press Enter

edited Apr 26, 2013 at 10:06

answered Mar 30, 2012 at 8:34

Baba

95.3k29 gold badges172 silver badges222 bronze badges

1 Comment

haltabush Over a year ago

If you type "NULL", it will insert a string 'NULL' => not OK (on 5.2.38 CE, rev 8753)

Collectives™ on Stack Overflow

How to set a field to NULL in MySQL Query Browser?

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related