更新数据.update

    用法如下：

    2. /*
    3. (
    4.     [name] => Array
    5.         (
    6.             [0] => 小猪
    7.             [1] => 2
    8.         )
    9. )
    10. */
    11. Db::table('test')->
    13. where('id', 503)->

    支持限制条件

    1. # UPDATE `test` SET `zt_test`.`name`=:name WHERE `test`.`id` = 503  LIMIT 0,2
    2. /*
    3. (
    4.     [name] => Array
    5.         (
    7.             [1] => 2
    8.         )
    9. )
    10. */
    11. Db::table('test')->
    13. where('id', 503)->
    15. top(2)->
    17. update(['name' => '小猪']);

    支持 join

    1. # UPDATE `test`  `t`  INNER JOIN `hello`  `h` ON `t`.`id` = `h`.`size` SET `t`.`name`=:name WHERE `t`.`id` = 503
    2. /*
    3. (
    4.     [name] => Array
    5.         (
    6.             [1] => 2
    7.         )
    9. */
    10. Db::table('test as t')->
    12. join('hello as h', '', 't.id', '=', '{[size]}')->
    14. where('id', 503)->
    16. update(['name' => '小猪']);

    表达式支持

    1. # UPDATE `test` SET `zt_test`.`name` = concat(`test`.`value`,`test`.`name`) WHERE `test`.`id` = 503
    2. /*
    3. (
    4. )
    5. */
    6. Db::table('test')->
    8. where('id', 503)->
    10. update([ 
    11.     'name' => '{concat([value],[name])}',