DELETE query in sql | Part 12 | SQL tutorial for beginners | Tech Talk Tricks



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.
#TechTalkTricks #RanaSingh

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

sql truncate…

sql tutorials

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *