clear table data sql code example
Example 1: delete all records from table
DELETE FROM table_name;
Example 2: delete query
public function deletedata(){
$this->db->where('id', 2);
$this->db->delete('table_name');
}
DELETE FROM table_name;
public function deletedata(){
$this->db->where('id', 2);
$this->db->delete('table_name');
}