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:

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

DELETE FROM TblStudent

WHERE Address IS NULL or Address='';

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


HTML Comment Box is loading comments...



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.