Sql like

like sql WHERE CustomerName LIKE ‘a%’ –Finds any values that start with “a” WHERE CustomerName LIKE ‘%a’ –Finds any values that end with “a” WHERE CustomerName LIKE ‘%or%’ –Finds any values that have “or” in any position WHERE CustomerName LIKE ‘_r%’ –Finds any values that have “r” in the second position WHERE CustomerName LIKE ‘a__%’ […]

Sql like Read More

Sql delete table

drop table DROP TABLE table_name; sql delete table Deletes a table from a database. Example: Removes the users table. DROP TABLE users; delete a table in sql DROP TABLE table_name; delete table DROP TABLE table_name; query to empty table data in sql server TRUNCATE TABLE table_name; delete sql DELETE FROM table_name WHERE condition;

Sql delete table Read More

Sql delete row from table

delete sql DELETE FROM table_name WHERE condition; sql delete row from table DELETE FROM table_name WHERE condition; sql delete row DELETE FROM Customers WHERE CustomerName=’Alfreds Futterkiste’; delete query public function deletedata(){ $this->db->where(‘id’, 2); $this->db->delete(‘table_name’); } sql delete where in — Deletes all records where `columnName` matches the values in brackets. DELETE FROM tableName WHERE columnName […]

Sql delete row from table Read More