Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Explain DELETE Statement in SQL ?

The delete statement is used to delete data from a table.  Be careful when using this command, it is easy to delete more data than intended.

Syntax:

 

DELETE FROM table_name  [WHERE condition];

 

If the where clause is omitted, all rows are deleted from the table. Depending on the use of the DELETE statement's WHERE clause, SQL can do the following:

Delete single rows

Delete multiple rows

Delete all rows

Delete no rows

Related Posts Plugin for WordPress, Blogger...
Flag Counter