DELETE FROM tablename;
DELETE FROM table USING another_table WHERE table.id = another_table.id;
public function deletedata(){ $this->db->where('id', 2); $this->db->delete('table_name'); }
DELETE FROM table WHERE condition;