SQL delect code example

Example 1: sql select

SELECT * FROM TABLE_NAME;

Example 2: sql select

Everything in brackets is optional.
SELECT [all/distinct] <COL1>, <COL2>, <COL3>
FROM <TABLE_NAME>
[JOIN <JOIN_CONDITION>]
[WHERE <CONDITION>]
[GROUP BY <COLUMN_NAME>]
[HAVING <SEARCH_CONDITION>]
[ORDER BY <SORT_SPECIFICATION>]

Example 3: delete query

public function deletedata(){	

	$this->db->where('id', 2);	
	$this->db->delete('table_name');

	}

Tags:

Sql Example

Related