>
> UPDATE forum, forum_thread set total_posts = total_posts + 1 where
> forum_thread.id = 1 and forum_thread.forum_id = forum.id
>
> Is there any way to do this using zend db or should do I have to create my
> sql manually.
>
Multi-table UPDATE and multi-table DELETE are not part of standard SQL.
These are MySQL extensions, as far as I know not supported by any other
brand of database. Currently you need to write the SQL manually and execute
it with the query() method.
Regards,
Bill Karwin
--
View this message in context: http://www.nabble.com/%24db-%3Eupdate%28...-Multiple-tables-tp19324333p19324457.html
Sent from the Zend DB mailing list archive at Nabble.com.
没有评论:
发表评论