Welcome to Tech Talk Tricks channel. In this video, we will learn how to use delete statement in SQL.
The DELETE Statement is used to delete rows from a table.
Syntax of a SQL DELETE Statement
DELETE FROM table_name [WHERE condition];
table_name — the table name which has to be updated.
NOTE: The WHERE clause in the SQL delete command is optional and it identifies the rows in the column that gets deleted. If you do not include the WHERE clause all the rows in the table are deleted, so be careful while writing a DELETE query without WHERE clause.
SQL DELETE Example
To delete an employee with id 100 from the employee table, the SQL delete query would be like,
DELETE FROM employee WHERE id = 100;
To delete all the rows from the employee table, the query would be like,
DELETE FROM employee;
sql delete multiple rows
delete query in oracle
sql delete join
delete query in mysql
delete all rows from table mysql
sql delete column