CODEWITHSUNDEEP
phpmysqlphpmyadmin
deltanovember
deltanovember

Reputation: 44061

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

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

Upvotes: 7

Views: 17776

Answers (3)

SergeS
SergeS

Reputation: 11779

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

( alternatievly, I prefer to use SQL language directly )

Upvotes: 8

Wolfram
Wolfram

Reputation: 8052

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

Upvotes: 1

gen_Eric
gen_Eric

Reputation: 227290

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

Upvotes: 3

Related Questions