MYSQL COMMANDS (Part - 1) Create Database | Data Types | char v/s varchar | Create Table | CBSE 12

[@architaray1177]

Thankyou ma'am..the only channel which helped me understand the concepts so well

[@SwatiChawlaofficial]

Welcome...🙏🏻😊 Keep watching...👍🏻

[@wriddhibiswas2732]

Tomorrow is my Exam Of IT and I was finding a vdo explanation of MySQL commands......and this helped me a lot, Thank you soo much Mam

[@SwatiChawlaofficial]

Welcome

[@vedikabasotia4026]

I'm in my 2nd year of engineering and revising SQL from Mam's channel gives me motivation ❤️

[@SwatiChawlaofficial]

Glad to hear this... Thanku so much 🙂🙏🏻 God bless you

[@karanrana1230]

Which engineering?

[@Edu_Gyan10]

Superb mam , MySQL ' s command aab jakar shmaj aayi 👍

[@SwatiChawlaofficial]

That's Great... Thanks.. Keep Watching

[@Aarzoo_Tamanna]

Way of teaching is awesome, speechless

[@SwatiChawlaofficial]

Thanku so much

[@shivanichoudhary4187]

After see this vedio my concept is well cleared....thanku mam...

[@SwatiChawlaofficial]

Welcome

[@Teenu]

thanks mam very good explanation you are my favorite teacher

[@SwatiChawlaofficial]

Glad to hear that... Thank You so much.. God bless you beta..

[@nikhil_hu]

Your voice mam😩😩

[@Tanushreeminivlog]

Thankyou ma'am your videos helped me a lot to understand concepts🥰

[@SwatiChawlaofficial]

Most welcome 😊

[@sLYvester.1946]

Ma'am im 2023-2024 batch students im following ur videos and questions from sumita arora is this enough for boards and thank u ma'am u explain better than my school teacher

[@SwatiChawlaofficial]

Yes... Thanks...

[@SwatiChawlaofficial]

Please check out this kzbin.info/www/bejne/haeyeomKhL9mbNU

[@neharikapuri7394]

Thank you mam ..the vedio was really amazing!

[@SwatiChawlaofficial]

Glad to like it..😊 Keep watching 👍🏻

[@bantosingh7088]

Wonderful teacher! I'm Just obsessed with your lectures ma'am. They are so easy to understand!

[@SwatiChawlaofficial]

Glad you like them! Thanku...

[@bantosingh7088]

@@SwatiChawlaofficial I'm glad Ma'am, That I found your channel!

[@SwatiChawlaofficial]

@@bantosingh7088 thanks.. Plz share with others too

[@navamisunil377]

Really helpful🥰....

[@SwatiChawlaofficial]

Thanku.... 🙏🏻😊

[@bhumikadash9426]

Thankyou mam You are awesome Am getting concepts very well and loving CS 🙏🙏

[@SwatiChawlaofficial]

That's Great 😊👍 Happy to help... Keep Watching

[@Amanyaduvanshi721]

aapki trh or sare teachers kyuo nhi h ??? u r a gem among cs teachers on yt.

[@SwatiChawlaofficial]

Thanku so much... 🙏🏻

[@k.lalithadithya5810]

thank you mam for the wonderful lecture 🤩😇🥰

[@SwatiChawlaofficial]

You're welcome! 😊

[@nibhakumari4999]

Mam you are awesome😀👌👍🏻👍🏻👍🏻

[@SwatiChawlaofficial]

Thanks

[@nibhakumari4999]

Wlcm

[@thatg1rl914]

at 3:00 what does that (0.11 sec) mean?

[@RajSingh-em4xd]

your teachng is so awesome sister thanks for understanding dear,god bless u,keep it up

[@SwatiChawlaofficial]

Thanks a lot

[@shampaghosh1241]

Great video ma'am help me a lot! Thank you!

[@SwatiChawlaofficial]

Thanks and Welcome..

[@Aszx_zx-g8f]

No doubts 🤓 thank you ma'am ❤️

[@SwatiChawlaofficial]

Welcome..

[@theindianlad222]

Very useful video for beginners.....

[@SwatiChawlaofficial]

Thanks a lot

[@terryroussel6060]

Thank you. Very much appreciated.

[@SwatiChawlaofficial]

Thanks and Welcome

[@Ayushmehla]

14:10 FLOAT(5,3) or number 12.2 type kiya to error aaiga kya ?

[@vikasthakur9271]

Sometimes i feel like maam you are angel to me for Computer Science 🙂

[@SwatiChawlaofficial]

Thanku so much... 🙏🏻😊

[@_poke_rock]

Wish i could have find this amazing channel in term 1.

[@SwatiChawlaofficial]

Thanku... Even now also... it's not too late..

[@_poke_rock]

@@SwatiChawlaofficial I scored 32/35 in term 1 Now thanks to you i can get 35/35 in term 2 Thanks Maam

[@Griffin_slacK556]

Very informative ❤️❤️

[@SwatiChawlaofficial]

Thanku

[@sashavinod8803]

thank you mam because of you i got 32/35 in term 1 boards

[@SwatiChawlaofficial]

Congratulations

[@dylanbenedict3898]

Say less

[@Teenu]

mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......

[@SwatiChawlaofficial]

Glad to hear that

[@Aman-yt5qk]

maam why you are doing this ? such a beautiful and conceptual content free of cost for all of us thank you so much maam

[@SwatiChawlaofficial]

Thanks and Welcome... Keep Watching

[@crazzysidd]

Wow great mam 😊

[@SwatiChawlaofficial]

Thanks

[@svikash6464]

Mam awesome i will recommend my frndns

[@SwatiChawlaofficial]

Thanks a lot

[@aspiringdude2743]

Ma'am at 16:42 when u r explaining abt varchar u have entered varchar(7)and for allocation of bytes 5 bytes to Swati and 4 bytes to ria so total 9 used for allocation so why not varchar (9)???

[@SwatiChawlaofficial]

Size in varchar specifies the maximum size of the particular column....

[@aspiringdude2743]

@@SwatiChawlaofficial ok thanku ma'am

[@Anime_Naruto31]

mam urs sql playlist includes 11th ( database concepts + sql) will it sufficient for me as i'm in 11th to complete both the chapters?

[@SwatiChawlaofficial]

Yes...

[@SHUBHI_GAMEING]

Thanku sssooo much

[@SwatiChawlaofficial]

Welcome

[@prakharagrawal8277]

Good content 👌

[@SwatiChawlaofficial]

Thanku

[@rext9183]

Ma'am thank you very much .

[@SwatiChawlaofficial]

Welcome..

[@neha2763]

Very nice 😊😊😊😊😊😊

[@SwatiChawlaofficial]

Thanku..🙏🏻😊

[@narayansinghtomar3250]

Mam can you please provide these sides for revision 🙏🏻

[@SwatiChawlaofficial]

Sure... You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@aditipandey498]

Thanks for such a wonderful explanation ❤️

[@SwatiChawlaofficial]

Welcome...

[@KesavanVenkateswaran]

Is int(m) self allocate itself ? If i give int(4) but in value if i give 2 dig no, then what happens

[@ARMY-wh3tu]

mam there is a problem it is showing error 1064 can you plz tell how to solve that

[@SHUBHI_GAMEING]

Thnx ma'am

[@SwatiChawlaofficial]

Welcome

[@RohanBisht95]

Thank you so much mama

[@SwatiChawlaofficial]

Welcome

[@hopendrasahu8845]

Tysm mam ❣

[@SwatiChawlaofficial]

Welcome

[@cadetshubham-i3e]

Thank you ma'am

[@SwatiChawlaofficial]

Welcome

[@sarita6883]

Maam ye apne classxii ki table kis pe bnai h??

[@opmistak3387]

Tks mam

[@SwatiChawlaofficial]

Welcome

[@humariduniya5235]

Apka bhai hai wo orange tshirt main?? Maam pls answer .(photos main )

[@onlyherefornature]

THANK YOU SO MUCH MA'AM IT HELPED ME A LOT. MA'MA APKA WHATSUP GROUP BHI HEIN KYA, HOGA TOH MUJHE BHI JOIN KARNA HEIN.

[@SwatiChawlaofficial]

Most welcome.. No whatsapp group is there

[@onlyherefornature]

Oh but before it was there know?

[@akashthakur3587]

Mam in the syntax of create table the place (rno int,name varchar (10) dob date , marks float (5,2),stream varchar (11)); how it comes?

[@parthdhande242]

mam i have a doubt, why does my mysql command line client keep opening in windows terminal, because of that i cannot access the properties and other features, any solution?

[@indiranamasivayam9174]

for double(m,d) default value is (16,4) for decimal(m,d) what is the default value?

[@fire_3221]

Maam , I have a doubt :- Is it possible to create a database inside another database .

[@utpalm9453]

Ma'am is there any difference between INT and INTEGER. Because in my programs I usually use INTEGER without any argument...

[@SwatiChawlaofficial]

Integer Types TINYINT - It Can Hold values from -128 to 127. Or 0 to 255 for Unsigned. SMALLINT -It can Hold values -32768 to 32767 or 0 to 65535 UNSIGNED. This is most commonly used field for most websites. MEDIUMINT - It can Hold values from -8388608 to 8388607 or 0 to 16777215 UNSIGNED. INT - It can hold Values from -2147483648 to 2147483647 or 0 to 4294967295 UNSIGNED. BIGINT - -9223372036854775808 to 9223372036854775807 normal. 0 to 18446744073709551615.

[@hansikagautam5437]

Mam when a domain is atomic... Please reply

[@SwatiChawlaofficial]

Atomic means data which cannot be divided further. Rules of atomicity: rule 1: a column with atomic data can't have several values of the same type of data in the same column. rule2: a table with atomic data can't have several columns with the same datatype. Like fullname column can't say that it could be atomic because it can be further divded into lastname, firstname. A column with interest could also be divided further, so a column which can't be divided is known as atomic.

[@hansikagautam5437]

@@SwatiChawlaofficial ok mam

[@kavalpreetbanga4508]

Thankyou mam ❤😇

[@SwatiChawlaofficial]

Welcome

[@k2vhal237]

@@SwatiChawlaofficial mam jo apne pdf post kiya tha na telegram me which had vid links usme galat link hai create databse showdatabse tht link is wrong

[@topperexam1826]

Mam commamdprompt're screen shot kaise lete hai mysql ka

[@SwatiChawlaofficial]

Either use Prtscr (Print Screen key) Or use Windows key + Shift + S

[@ramaniravi7932]

Please share your PPT it's very use full . please please

[@SwatiChawlaofficial]

*Hey, now you can avail all these notes at the discounted rate….* *Class - X Information Technology* * Employability Skills (Notes) - X rzp.io/l/1mcA8UL * Employability Skills (Ques Ans) - X rzp.io/l/2hxw8tY6N * NCERT Solutions of CBSE Class 10 IT 402 rzp.io/l/fKUADxvbv * Unit - 1 Digital Documentation Advanced using LibreOffice rzp.io/l/GUhTNcTpH * Unit - 2 Electronic Spreadsheet Advanced (using LibreOffice) rzp.io/l/PpBEONKRN * Unit - 3 DBMS (based on LibreOffice Base) rzp.io/l/XJrYs2P * Unit - 4 Managing Health and Safety rzp.io/l/TQWvwOa *Class 11 Computer Science (083)* * Python rzp.io/l/cKflR95C *Class 12 Computer Science (083)* * Computational Thinking & Programming - 2 rzp.io/l/wihJhPBO * Computer Networks rzp.io/l/OKWrgua * Database Management rzp.io/l/z0mu2uBVu * Assertion and Reasoning rzp.io/l/TgngGDjb *IMPORTANT : After successful payment, don't refresh or go back (Redirecting...... will be shown on screen) , just wait for a while, and then Click on Request Access button, then you will get access to notes on your G-Mail ID within 24 hours.*

[@ahsabhasan8751]

Also mam will there will be error if we write commands in small letters??

[@SwatiChawlaofficial]

No error... SQL is case insensitive language

[@SwatiChawlaofficial]

No error... SQL is case insensitive language

[@shwetarathaur9933]

ma'am in create table command each time we press enter we get to a new line ........so in written exams we need to write them in different lines or we can continue on same line.

[@SwatiChawlaofficial]

Your choice .. Even practically also... U can write in a single line as well

[@shwetarathaur9933]

@@SwatiChawlaofficial ok mam......thank u so much for such wonderul sessions.

[@vrindavasudev6734]

thanku

[@SwatiChawlaofficial]

Welcome

[@ahsabhasan8751]

Mam why to put semicolon after every command?

[@SwatiChawlaofficial]

Semicolon represents the end of the statement..

[@ahsabhasan8751]

thank you mam

[@explorerars4208]

thank you mam

[@SwatiChawlaofficial]

Most welcome 😊

[@neelamsrivastava5651]

Ma'am I have a query between char and varchar If we more than 7 what will happen in char and varchar As you write swati but if I write swati chawla ma'am please help me

[@SwatiChawlaofficial]

Plz Check out this kzbin.info/www/bejne/eHzMqGimfr14hZY

[@neelamsrivastava5651]

@@SwatiChawlaofficial thankyou so much ma'am

[@nikhilllls]

Mam ❤️

[@SwatiChawlaofficial]

🙏🏻

[@biswajitsahoo8407]

mam can you please say which are the most imp datatypes only

[@SwatiChawlaofficial]

char, varchar,int,date

[@Ashumaurya52]

🎭 AMAZING SESSION MAM ✌️

[@VardhanMittal]

Mam have you made video on datatype.char varchar

[@SwatiChawlaofficial]

kzbin.info/www/bejne/paOqkqmYbqpsq9k

[@ssubhashini6121]

Ma'am, is "views in database" there in term 2 syllabus? If yes, then pls make a video on this topic also🙏.. Edit :Ma'am pls make a video on referential integrity also if it is there in the syllabus.. My school teacher is teaching these topics so I am having confusion whether they are there or not..

[@SwatiChawlaofficial]

plz refer the video of keys and constraints

[@ssubhashini6121]

@@SwatiChawlaofficial Ok ma'am but are the topics mentioned in my comment there in the syllabus? I have already studied from the whole Playlist of DBMS but didn't find those topics.. Kindly clarify ma'am so that I can study according to the syllabus.. Sorry for disturbing you repeatedly 🙏

[@SwatiChawlaofficial]

According to me and even your teacher as well, these topics are important... Don't restrict yourself to syllabus only... I suggest you to cover these topics...

[@ssubhashini6121]

@@SwatiChawlaofficial Ok ma'am thanks a lot.. Can you pls provide me a link to the video(s) where these topics have been covered by you? Sorry for inconvenience..

[@somya3575]

Ma'am ye (0.10 sec) or (0.11 sec) or (0.00 sec) ye sbb kya or kyun likha aata h MySQL k code me??

[@VarunSrinivas]

it is the time the program has taken to execute your command bro

[@pk471]

assume swathi chawla. thank you very much.

[@hansikagautam5437]

Mam phn m sqlite Kse krna h

[@SwatiChawlaofficial]

Check Termux or Compiler app from Playstore..

[@hansikagautam5437]

@@SwatiChawlaofficial mam tcl commands important h kya

[@hansikagautam5437]

Usme commit smjh n a rha h

[@hansikagautam5437]

@@SwatiChawlaofficial thank you so much mam

[@JaiPrakash-jn9ej]

Ma'am everytime I am trying to create a database,it shows unexpected identifier....please Ma'am help!!!!

[@masterpiece5605]

Mam how to enter value in database in my sql

[@SwatiChawlaofficial]

MYSQL: kzbin.info/aero/PL5Raijva2y4S2sDeMIMu1kAVjwjgWyvyK

[@deepanshugarg26]

mam mujhe my sql 8.0 command line lient open krne mei problem aa rhi ae

[@SwatiChawlaofficial]

kzbin.info/www/bejne/jnuxfappjJyrm9k Also check out the description of this video

[@mansirawat2524]

Mam window 7 m kese kre mql download pls mam reply

[@SwatiChawlaofficial]

kzbin.info/www/bejne/jnuxfappjJyrm9k follow same procedure..

[@utpalm9453]

Difference between decimal and float datatype?

[@SwatiChawlaofficial]

DECIMAL and FLOAT both are used to store numerical values. Float is Approximate-number data type, which means that not all values in the data type range can be represented exactly , it round up the values. where as Decimal is Fixed-Precision data type, which means that all the values in the data type range can be represented exactly with precision and scale, it doesn’t round up the values.

[@jatinbanara5341]

Mam can the database & have table inside it same name ?? Please mam

[@SwatiChawlaofficial]

yes

[@tiyasinha7763]

Ma'am can you please tell me any android app for accessing MySQL

[@SwatiChawlaofficial]

play.google.com/store/apps/details?id=app.compiler

[@Miinii_me]

Ma'am ek baat bolu galti karte huye mai use erase nhi kar pa rhi

[@SwatiChawlaofficial]

Usse arrow keys

[@Miinii_me]

@@SwatiChawlaofficial ok ma'am

[@utpalm9453]

If the datatype is float(4,2) .. then is 234.4 a valid input?

[@SwatiChawlaofficial]

This will be invalid input as float(4,2) means..u r fixing that after decimal..it will take 2 digits.. before decimal,it will accept either 1 or 2 digits..not more than that.. Hope it's clear now..😊

[@utpalm9453]

@@SwatiChawlaofficial yes ma'am.. crystal clear...😊

[@utpalm9453]

Ma'am can the database and table inside it have same name?

[@SwatiChawlaofficial]

Very Good Question.. Yes... the name of the database and table can be same.. But inside the databse, two tables can not have the same name..

[@utpalm9453]

@@SwatiChawlaofficial Thank you so much ma'am... you are awesome...😊😀

[@narayansinghtomar3250]

Mam if I didn't have a pc then I can't learn??

[@SwatiChawlaofficial]

U can use online compilers or Apps in Android.. like Pydroid3 , Compiler..

[@मेराभाईमेराभाई]

Plzz ensure that we can change the speed of the video

[@Sanju-mo6in]

U can change it in KZbin. Just click on the three dots->playback speed and adjust to your comfort.

[@मेराभाईमेराभाई]

@@Sanju-mo6in 11 month pehla nhii show karta ha playback speed samgha babu

[@mayankroy208]

mam where are you from

[@preethiv4092]

Can u send this ppt

[@SwatiChawlaofficial]

*Hey, now you can avail all these notes at the discounted rate….* *Class - X Information Technology* * Employability Skills (Notes) - X rzp.io/l/1mcA8UL * Employability Skills (Ques Ans) - X rzp.io/l/2hxw8tY6N * NCERT Solutions of CBSE Class 10 IT 402 rzp.io/l/fKUADxvbv * Unit - 1 Digital Documentation Advanced using LibreOffice rzp.io/l/GUhTNcTpH * Unit - 2 Electronic Spreadsheet Advanced (using LibreOffice) rzp.io/l/PpBEONKRN * Unit - 3 DBMS (based on LibreOffice Base) rzp.io/l/XJrYs2P * Unit - 4 Managing Health and Safety rzp.io/l/TQWvwOa *Class 11 Computer Science (083)* * Python rzp.io/l/cKflR95C *Class 12 Computer Science (083)* * Computational Thinking & Programming - 2 rzp.io/l/wihJhPBO * Computer Networks rzp.io/l/OKWrgua * Database Management rzp.io/l/z0mu2uBVu * Assertion and Reasoning rzp.io/l/TgngGDjb *IMPORTANT : After successful payment, don't refresh or go back (Redirecting...... will be shown on screen) , just wait for a while, and then Click on Request Access button, then you will get access to notes on your G-Mail ID within 24 hours.*

[@shivamshukla1347]

Thank you mam you teach very well ❤️‍🩹

[@SwatiChawlaofficial]

Welcome

[@heyVishnu75]

ma'am please change the intro music...its a bit too loud.

[@SwatiChawlaofficial]

Yes.... You are right... Actually this is my old video ... In new videos, i have removed this... Sorry for the inconvenience caused 🙏🏻

[@heyVishnu75]

@@SwatiChawlaofficial no problem ma'am. i have been a viewer since class 10th now im in 12th and i chose CS because i knew i can depend on your videos to study. thankyou very much☺🙏

[@SwatiChawlaofficial]

Thanks and Welcome

[@shrill_kill9929]

Notes ?

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@suryanshsingh2347]

Mam aap 0.5 slow ho

[@sricharansrikrishna3259]

2022 batch

[@jasmeetsinghbal7218]

mam you missed the drop database command

[@SwatiChawlaofficial]

The DROP DATABASE statement is used to drop an existing SQL database. Syntax DROP DATABASE databasename;

[@jasmeetsinghbal7218]

@@SwatiChawlaofficial thanks mam

[@sakshisakshi2495]

Please ma'am upload pdf notes provide

[@SwatiChawlaofficial]

Sure... You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@goutamsinghrajput5539]

Showing no data base

[@SwatiChawlaofficial]

First create database, then use database

[@pirategaming7620]

Kalpana chawala is your mouse or what😂

[@lovemusical4058]

Thanku mam🙂

[@SwatiChawlaofficial]

Welcome

[@deepsahu2783]

thankyou ma'am

[@SwatiChawlaofficial]

Welcome

[@rishavkumar_Pandit]

Thanks mam 🙏

[@SwatiChawlaofficial]

Welcome..

[@Aves7]

Thanks mam

[@SwatiChawlaofficial]

Welcome...

[@usye8802]

Thank you mam

[@SwatiChawlaofficial]

Welcome