[thelist] Setting a MySQL value to NULL using PHP

John Corry webshot at members.evolt.org
Tue Apr 30 15:48:01 CDT 2002

I think this si an SQL problem. PHP is just a way to run a query against the
database, no different than if you did it from the command line, right?

NULL should be 'NULL', incidentally...

I just did a similar query from PHPMyAdmin where I tried updating a
'auto_increment' column, it said 'error: duplicate entry 0' which makes

Next I tried it on a column that is specified as 'not null' and has a
default value of '0'. The query updated the field to have a value of '0'.

Next I tried it on a column specified as 'null' (or, not 'not null') and
with a default value left blank. The fields were updated to have a value of

It seems like 'NULL' will always put a value of '0' in a field...

Does that help?


More information about the thelist mailing list