Take varchar for address(set size according to your needs) Case 1: if u take class and section together, use varchar to store both together. (Take size according to ur needs.) Ex- "6 A" or "VI A" Case 2: class and section separately For section, take varchar(1). (Size is 1 as sections are generally between A-Z. U can take according to ur needs too) Case 2.1: if class is taken as 6, 7, etc, use int Case 2.2: if class is taken as VI, VII, etc, then use varchar. Take size according to needs.
Hi bro I have installed the sql by seeing ur video thank you soo much for ur kind explanation. But as I was practicing I cant able to insert date init it is showing incorrect date value what is the problem
@@EverythingComputerized 1. when to use decimal and when to use float? as both are point values. String data type: you said it is used to store name, address etc. Address has numbers special characters and words. 2. difference between char and varchar: you said char can take upto 8000 characters. then for varchar in example you have taken varchar(20) but 20 can be put in CHAR also right? as CHAR can take upto 8000 cahracaters. When to use Char and when to use varchar? 3. difference between char and varchar you said Varchar length can be changed, then you are saying we have to put varchar(20) and the value cant be changed.
1. For decimal and float, u can see the range and precision. Depending on them, u can use as per ur use.. read the following article for the same. www.catapultsystems.com/blogs/float-vs-decimal-data-types-in-sql-server/ Strings can store any type of character. Thats why for address we use string as it can contain alphabets, numbers and also special characters. In simple words, String is a sequence of characters, where characters can be anything.
2. For difference between Char and Varchar, u can read the following article. www.geeksforgeeks.org/char-vs-varchar-in-sql/ This will hopefully clear your doubt
Plz correct date format it's not dd-mm-yyyy it's yyyy-mm--dd
3 hrs more to my exam and you saved me. Thank you very much!
Hope ur exam went well!
I didn't get how to choose data size canyou explain?
No😂@@pujagurung917
Vo content nhi h apka jesa sbko chahiye
I'll surely improve! Thanks for review!
You're doing an outstanding job so far. Kudos from Tunisia
Thank you😃
Tomorrow is my paper and u just save me 🥺 again thank you bro
I wish you all the best for your exams bro👍👍
Thankk youuuuu and i am girl 😂🤣
I'm so sorry😅😅 all the best sis🤭
Best Explaination Ever : )
Thanks man!
Thank you very much, sir.
God bless you immensely
Thank you!
Amazing you are ! Keep it up 🌻
Thank you so much!!
Thank you so much I really like this video so helpful
😃🙌
Thank you so much 💜
😄❤
😍 love you bro
🤗🙌
Please make more videos on DBMS
I'm currently working on it, and will release it soon. Thanks for being patient. Keep supporting us❤
Bro plz tell ki adress ke liye konsa data type and class nd section ke liye konsa data type plz tell
And aadharno mai bhi plz tell bro
Take varchar for address(set size according to your needs)
Case 1: if u take class and section together, use varchar to store both together. (Take size according to ur needs.) Ex- "6 A" or "VI A"
Case 2: class and section separately
For section, take varchar(1). (Size is 1 as sections are generally between A-Z. U can take according to ur needs too)
Case 2.1: if class is taken as 6, 7, etc, use int
Case 2.2: if class is taken as VI, VII, etc, then use varchar. Take size according to needs.
@@EverythingComputerized and for aadhar no?
For adhaar no, use decimal with 12 integer digits, and 0 fractional digits.
Use the following data type declaration -
*DECIMAL(12,0)*
@@EverythingComputerized can we use.int?
Hi bro I have installed the sql by seeing ur video thank you soo much for ur kind explanation. But as I was practicing I cant able to insert date init it is showing incorrect date value what is the problem
There might be a syntax error..
Please watch the sql tutorial..
Its present on my channel.
Excellent job
🙏🙂🙌
Thanks
👍
Please when do we use int et when do we use varchar?
int is for numeric type, varchar is for variable string
Where we store 5000 characters
Varchar
do teen jagah mein confuse kar diya aapne.😕
Kahan Kahan?
@@EverythingComputerized
1. when to use decimal and when to use float? as both are point values.
String data type: you said it is used to store name, address etc. Address has numbers special characters and words.
2. difference between char and varchar: you said char can take upto 8000 characters. then for varchar in example you have taken varchar(20) but 20 can be put in CHAR also right? as CHAR can take upto 8000 cahracaters. When to use Char and when to use varchar?
3. difference between char and varchar you said Varchar length can be changed, then you are saying we have to put varchar(20) and the value cant be changed.
1. For decimal and float, u can see the range and precision. Depending on them, u can use as per ur use.. read the following article for the same.
www.catapultsystems.com/blogs/float-vs-decimal-data-types-in-sql-server/
Strings can store any type of character. Thats why for address we use string as it can contain alphabets, numbers and also special characters. In simple words, String is a sequence of characters, where characters can be anything.
2. For difference between Char and Varchar, u can read the following article.
www.geeksforgeeks.org/char-vs-varchar-in-sql/
This will hopefully clear your doubt
3. This doubt wasn't clear to me. Can u pls elaborate?
𝙂𝙚𝙟𝙚
?