How to Create Table with Collation, Attributes, Default, Auto_Increment, Virtuality #3 | SQL TABLE
1. is video me mysql table ko GUI or CUI yani ki Query ka upyog kar Create or Drop karna bataya hain.
2. sath tme Collation ka upyog kar Character Set karna Unicode ke liye uske bare me bhi bataya hain.
3. Attribute Unsigned or Unsigned ZeroFill ka example bhi bataya hain
4. Nul or Not Null ka upyog
5. First Time Insert ke samay Default Value Set karna
6. Auto Increment kaise set kiya jata hain
7. Virtuality option (VIRTUAL_GENERATED or STORED_GENERATED) ka example bataya hain
Read Blog
https://selfimagination.in/tips/mysql...
Time
00:00 Creat Table
03:04 Data Type
03:23 Length
06:05 Default Value
07:43 Collation
08:26 Null / Not Null
09:05 Index (Primary Key / Unique )
09:58 Auto Increment
10:21 Virtuality (Virtual, Stored)
17:37 Attributes
20:50 Drop Table
21:09 Table Create/Drop Using Query
#mysql #hindi #learnmysql #createtable