//UPDATE se_system_loginlog SET id = :id, username = :username WHERE id = :where_id_0
$userObj = M('system_loginlog');//不会load所有字段
$userObj->id = 4;
$userObj->username = 'ZENGYI';
$userObj->update();


//UPDATE se_system_loginlog SET id = :id, username = :username, password = :password, ip = :ip, addtime = :addtime WHERE id = :where_id_0
$userObj = get('system_loginlog', 2);//会load这张表的所有字段
$userObj->username = 'adamzeng1';
$userObj->update();

1. 简单条件更新
说明：通过单个条件更新记录。
示例：
//UPDATE se_system_plugins SET name = :name WHERE id = :where_id_0
$userObj = get('system_plugins', 2); //主键不影响
$userObj->where(['id' => 1])->data(['name' => 'John'])->update(); //只update了id=1的记录的name值

2. 多条件更新
说明：通过多个条件更新记录。
示例：
//UPDATE se_system_plugins SET name = :name WHERE name = :where_name_0 AND id < :where_id_1
$userObj = M('system_plugins');
$userObj->where(['name' => ['=', 'John'], 'id' => ['<', 18]])->data(['name' => 'Tom'])->update();//传了data的，都是指定字段更新

3. 使用 IN 操作符
说明：通过 IN 操作符更新多个记录。
示例：
//UPDATE se_system_plugins SET disabled = :disabled WHERE id IN :where_id_0
$userObj = M('system_plugins');
$userObj->where(['id' => ['IN', [1, 2, 3]]])->data(['disabled' => '1'])->update();

4. 使用 BETWEEN 操作符
说明：通过 BETWEEN 操作符更新记录。
示例：
//UPDATE se_user_client_online SET user_num = :user_num WHERE addtime BETWEEN :where_addtime_0
$userObj = M('user_client_online');
$userObj->where(['addtime' => ['BETWEEN', ['2025-03-17 09:30:02', '2025-03-17 19:30:01']]])->data(['user_num' => 100])->update();//不支持

5. 使用 LIKE 操作符
说明：通过 LIKE 操作符更新记录。
示例：
//UPDATE se_system_plugins SET author = :author WHERE folder LIKE :where_folder_0
$userObj = M('system_plugins');
$userObj->where(['folder' => ['LIKE', '%pay%']])->data(['author' => 'sebigdata'])->update();

6. 使用 NOT IN 操作符
说明：通过 NOT IN 操作符更新记录。
示例：
//UPDATE se_system_plugins SET author = :author WHERE id NOT IN :where_id_0 AND id < :where_id_1
$userObj = M('system_plugins');
$userObj->where(['id' => ['NOT IN', [1, 2, 3]]])->where(['id' => ['<', 10]])->data(['author' => 'active'])->update();//不支持