使用Zend_Db时如何将值设置为NULL [英] How to Set a Value to NULL when using Zend_Db

问题描述

使用Zend_Db执行UPDATE和INSERT查询时，我经常需要将值设置为NULL(不是").但是，Zend_Db :: insert()和Zend_Db :: update()的默认行为似乎是将空值转换为空字符串('')并照此放入数据库.

When performing UPDATE and INSERT queries using Zend_Db, I frequently need to set values equal to NULL (not ''). However, the default behavior of Zend_Db::insert() and Zend_Db::update() seems to be that values that are empty are translated into empty strings ('') and put into the database as such.

有人知道如果php中的NULL值为空时，实际上会强制将NULL值输入字段吗?

Does anyone know of way to actually force a NULL value to go into fields if the value is empty in php?

推荐答案

尝试将受影响的字段设置为: new Zend_Db_Expr('NULL')

Try setting the affected fields to: new Zend_Db_Expr('NULL')

这篇关于使用Zend_Db时如何将值设置为NULL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！