How do I set a string field to NULL in phpmyadmin?

Question

If I type NULL, it is treated as a string literal. If I leave it blank it is treated as an empty string.

Are you talking about setting it in the table definition, or when setting the value of a column in a row? — BoltClock
– BoltClock, Commented Mar 1, 2011 at 20:50
And if you're talking about setting a column value, are you using the Insert tab, or an actual SQL statement? — EmmyS
– EmmyS, Commented Mar 1, 2011 at 20:52

gen_Eric · Accepted Answer · 2011-03-01 20:55:04Z

9

There must be a checkbox near input for setting NULL value. ( only on nullable columns )

( alternatievly, I prefer to use SQL language directly )

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

answered Mar 1, 2011 at 20:51

SergeS

11.9k3 gold badges31 silver badges35 bronze badges

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

Comments

gen_Eric · Accepted Answer · 2011-03-01 20:52:21Z

3

In phpMyAdmin, there should be a checkbox next to the text field. Checking that should make the field NULL.

If you're using a query, it is:

UPDATE table SET field = NULL WHERE id = 4

answered Mar 1, 2011 at 20:52

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Wolfram · Accepted Answer · 2011-03-01 20:52:28Z

1

Just tick the checkbox in the NULL column (and make sure that NULL is allowed for that field).

answered Mar 1, 2011 at 20:52

Wolfram

8,0973 gold badges49 silver badges69 bronze badges