drop rows from table sql code example
Example 1: sql delete row from table
DELETE FROM table_name WHERE condition;
Example 2: how to delete multiple rows in sql
// in order to do such use between keyword
delete from students
where id between 6 and 10
Example 3: delete query
public function deletedata(){
$this->db->where('id', 2);
$this->db->delete('table_name');
}