How do I add a limit to update-query in Zend Frame

2019-02-19 02:17发布

How do I add the LIMIT 1 clause to an update when using Zend Framework?

I'm kind of forced not to use Zend_Db_Table_Abstract::update() since it executes itself unlike the sweet Zend_Db_Select-classes.

The reason to do this is just precaution and I think Zend_Db_Table_Abstract::update()'s syntax makes more sense when found in code than the more allround Zend_Db_Adapter_Abstract::query().

2条回答
唯我独甜
2楼-- · 2019-02-19 02:52

Why would you want to do that??? If you want to update a single record you should use the records' primary key and use an

UPDATE <table> SET field=<newvalue>, ... WHERE key = <keyvalue>;

query.

查看更多
地球回转人心会变
3楼-- · 2019-02-19 03:00

You can not.

There is an issue created for this exact problem at the issue tracker. But this feature is still not implemented.

查看更多
登录 后发表回答