KwickClips Databases and SQL · 42 sec · free
Which type stores 85.5?
Short answer. FLOAT.
How is a date written?
As YYYY-MM-DD, like '2026-08-15'.
Five data types
| Type | Stores |
|---|---|
| CHAR / VARCHAR | text |
| INT | 42 |
| FLOAT | 85.5 |
| DATE | 2026-08-15 |
Remember
| CHAR fixed, VARCHAR varies |
| Dates: YYYY-MM-DD |
Which type stores a date of birth? Char and var char store text. Int stores whole numbers. Float stores decimals. Date stores year, month and day. Char is fixed length. Var char varies. Dates go year, month, day.
This clip is from the full lesson: Introduction to SQL and MySQL: DDL, DML and DQL — 7 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 12 Computer Science (083), CBSE Class 11 Informatics Practices (065), CBSE Class 11 Information Technology (802), CBSE Class 11 Information Technology (802)
More KwickClips from this lesson
Voice-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.