## 主要采取關鍵字有： > update > setField > setInc > setDec > save > update ## 更新數據表中的數據 ~~~ Db::table('think_user') ->where('id', 1) ->update(['name' => 'thinkphp']); //或則根據主鍵更新 Db::table('think_user') ->update(['name' => 'thinkphp','id'=>1]); ~~~ ## 更新某個字段的值 ~~~ Db::table('think_user') ->where('id',1) ->setField('name', 'thinkphp'); ~~~ ## 自增或自減一個字段的值 ~~~ // score 字段加 1 Db::table('think_user') ->where('id', 1) ->setInc('score'); // score 字段加 5 Db::table('think_user') ->where('id', 1) ->setInc('score', 5); // score 字段減 1 Db::table('think_user') ->where('id', 1) ->setDec('score'); // score 字段減 5 Db::table('think_user') ->where('id', 1) ->setDec('score', 5); ~~~ ## 延遲更新 ~~~ Db::table('think_user')->where('id', 1)->setInc('score', 1, 10); ~~~ ## 查找并更新 ~~~ $user = User::get(1); $user->name = 'thinkphp'; $user->email = 'thinkphp@qq.com'; $user->save(); ~~~ ## 直接更新數據 ~~~ $user = new User; // save方法第二個參數為更新條件 $user->save([ 'name' => 'thinkphp', 'email' => 'thinkphp@qq.com' ],['id' => 1]); ~~~ ## 批量更新數據 ~~~ $user = new User; $list = [ ['id'=>1, 'name'=>'thinkphp', 'email'=>'thinkphp@qq.com'], ['id'=>2, 'name'=>'onethink', 'email'=>'onethink@qq.com'] ]; $user->saveAll($list); //或則(遍及更新) foreach($list as $data){ $user->data($data,true)->isUpdate(true)->save(); } ~~~ ## 通過數據庫類更新數據 ~~~ $user = new User; $user->where('id', 1) ->update(['name' => 'thinkphp']); //或則 $user->update(['id' => 1, 'name' => 'thinkphp']); ~~~ ## 靜態方法 ~~~ User::where('id', 1) ->update(['name' => 'thinkphp']); //或則 User::update(['id' => 1, 'name' => 'thinkphp']); ~~~ ## 閉包更新 ~~~ $user = new User; $user->save(['name' => 'thinkphp'],function($query){ // 更新status值為1 并且id大于10的數據 $query->where('status', 1)->where('id', '>', 10); }); ~~~