KwickClips Databases and SQL · 36 sec · free
How do you delete one student?
Short answer. DELETE FROM student WHERE roll = 3.
Does DELETE remove the table?
No. Only rows.
Remember
| DELETE removes whole rows |
| No WHERE: all rows gone |
How do you remove just one student from a table? Delete from student where roll equals three removes only that row. Without where, every row goes. Delete removes whole rows. No where means all rows go.
This clip is from the full lesson: SQL Data Manipulation: INSERT, UPDATE and DELETE — 5 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 9 Computer Applications (165), CBSE Class 9 Computer Applications (165), CBSE Class 9 Computer Applications (165), CBSE Class 9 Information Technology (402)
More KwickClips from this lesson
What does a skipped column get?37 sec
Why did all marks become 80?38 sec
How do you confirm an UPDATE?35 secVoice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.