How To Update Mysql Database Table Field Where Is Null

i will teach you how to update mysql database table field where is null [1226], Last Updated: Sat May 18, 2024

wallpaperama

Sun Dec 21, 2008

8 Comments

5817 Visits

today i was breaking my head because i wanted to update a table which had a field where the default value was NULL

so in case you are in the same situation as i am today, this is how you would send a query to update a field where the value is NULL

$Query= "UPDATE table_name SET FieldName =1229883373 WHERE FieldName IS NULL"

hope this helps

Kaustubh

Fri Nov 12, 2010

I know this.But now my problem is I want to set field to null,which has default value NULL and data type int so it updates it to 0 (zero). But I have use zero as a value in my code. so can I update it to NULL

bikes

Tue Mar 06, 2012

thanks machaaaaaa....

https://www.wallpaperama.com/forums/how-to-update-mysql-database-table-field-where-is-null-t6899.html

T-MATT

Tue Dec 20, 2011

UPDATE `comics` SET `cover_price`=' WHERE NULL dows not work as you suggested. I am trying to do this on the mysql end not php end.

aira

Mon May 16, 2011

thank you very much! :)

Micha

Thu Feb 24, 2011

Great, thanks so much :-)

How To Make A String Or Word Into An Array Of Elements in PHP

How To Update Mysql Database Table Field Where Is Null

Related Pages