mysqldecimal空,十进制字段的mysql更新语句为NULL或空

Can&＃39;t figure out, how to update decimal field to null or emptiness.

Have tried:

UPDATE ads SET price&＃61;NULL WHERE price&＃61;0

And

UPDATE ads SET price&＃61;"" WHERE price&＃61;0

Isn&＃39;t working.

Thanks ;)

(Update)

Just a moment.

解决方案UPDATE ads SET price&＃61;NULL WHERE price&＃61;0

That is the correct way to set a field to NULL. However it will not work if the column does not allow NULL.

If you have the CREATE statement for that table available, check if it says NOT NULL for the price column.

If you don&＃39;t have the CREATE statements you can run &＃39;DESC ads&＃39; on oracle or mysql and see if NULL is allowed.