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 table

the delete statement conflicted with the reference constraint
At tech talk trick channel you will learn all kind of technology like language,tutorials and amazing computer tips and tricks.
**************************************************
Follow Tech Talk Trick on Facebook
**************************************************
Follow tech talk trick on Twitter
**************************************************
Follow Tech Talk Tricks on Instagram
**************************************************
Subscribe tech talk tricks on YouTube
***************************************************