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


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

TblStudent table:

StuID StuName Sex DOB Address Tel
S001Sao VirakF 12-02-1982 #234, st. 230, Phnom Penh 0897654678
S002Sok LidaM 03-06-1984 Chambak Bati Tramkna 092767896
S003Cheng SokunF 09-09-1987   090543123


WHERE Address IS NULL or Address='';

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


KrishnaMohan comment


Its simply superb.Feeling good to share the link to practice sql interview quetions http://skillgun.com/sql/interview-questions-and-answers


This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.