SQL tutorial-Delete data

Delete data

To delete data from a table you can use the DELETE statement
The DELETE statement has the following syntax:

DELETE FROM Table-name

[WHERE...];

Example: Delete all student's records that don't have Address.

TblStudent table:

DELETE FROM TblStudent

WHERE Address IS NULL or Address='';

Note: Without WHERE clause, you will delete all rows of the table