codeigniter 4无法更新数据库

public $default = [
    'DSN'      => 'mysql:host=localhost;dbname=your_database',
    'hostname' => 'localhost',
    'username' => 'your_username',
    'password' => 'your_password',
    'database' => 'your_database',
    'DBDriver' => 'MySQLi',
];

$updateData = [
    'column_name' => 'new_value'
];

$this->db->table('table_name')->update($updateData);

$this->db->transBegin();

try {
    $this->db->table('table_name')->update($updateData);
    $this->db->transCommit();
} catch (\Exception $e) {
    $this->db->transRollback();
    // 处理异常
}

echo $this->db->getLastQuery(); // 打印最后执行的 SQL 语句

// 在控制器中
public function updateRecord($id)
{
    $model = new YourModel();

    $data = [
        'column1' => 'new_value1',
        'column2' => 'new_value2',
    ];

    $result = $model->update($id, $data);

    if ($result) {
        echo "更新成功";
    } else {
        echo "更新失败: " . $model->errors();
    }
}

// 在模型中
public function update($id, $data)
{
    return $this->db->table('your_table')->update($data, ['id' => $id]);
}