Update with limit 1 in codeigniter use active reco

问题:

I'm trying to update a single record with the active record of codeigniter and it still fails.

$data = array('status' => 1);

$this->db->where('field1', $info);
$this->db->update('example', $data);
$this->db->limit(1);

When i run updates all fields of the database. By making a $ this->db->last_query() does not show me the limit

What is the error

回答1:

Move the limit before the update which should be always called last:

$this->db->limit(1);
$this->db->update('example', $data);