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:

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




Comments

Name:
Comment:
Enter the text:
CAPTCHA image

.........................................................................................................................Home | Forum | About | Contact
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.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.
Home Programming Web DB & App Questions Exercises Tips Programs FAQs Download About
Computer-Wbest
Popular Pages
You might like