KwickClips Databases and SQL · 37 sec · free
What does a skipped column get?
Short answer. Its DEFAULT value, or NULL.
Do numbers need quotes?
No. Only text and dates do.
Remember
| With names: may skip columns |
| Without: every column, in order |
Do you have to write column names in insert? No. With names, you can skip a column. Without names, give every column, in table order. With names, you may skip columns. Without names, fill every column in order.
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
Why did all marks become 80?38 sec
How do you delete one student?36 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.