drop every row sql code example
Example 1: sql delete all values in a column
UPDATE TableName SET ColumnName = NULLExample 2: delete query
public function deletedata(){
$this->db->where('id', 2);
$this->db->delete('table_name');
}UPDATE TableName SET ColumnName = NULLpublic function deletedata(){
$this->db->where('id', 2);
$this->db->delete('table_name');
}