MYSQL COMMANDS (PART-4)| DISTINCT | BETWEEN | IN | LIKE | IS NULL | CBSE CLASS 12 | COMPUTER SCIENCE

[@harshchhoker3295]

Examples are best way to learn !! Mam like your way of teaching... Keep it up 👍

[@SwatiChawlaofficial]

Thanku... Keep Watching

[@shivamkumaryadav6724]

Maam you explain 10 times better than my school teacher .. Thank you Respect from deep of my heart Love you maam ❤️ 💙 💜 💖

[@SwatiChawlaofficial]

Thanks 🙏🏻

[@Teenu]

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

[@SwatiChawlaofficial]

You are most welcome

[@smalikmalik4150]

Mam i want to ask that..ur lectures are sufficient na for our board exam!!!

[@SwatiChawlaofficial]

Yes.. I have covered all d contents... Do d practice of Questions

[@kripashankar_yadav]

Your explanation if marvelous.please keep it up mam.

[@SwatiChawlaofficial]

Thanku... 🙏🏻😊

[@PhilosophyOfGreatests]

Thanks for teaching practically...

[@SwatiChawlaofficial]

Most Welcome..🙏🏻😊

[@ShivamSingh-dv1yx]

Thx ma'am. I found this video great ful for me and my all doubt clear

[@SwatiChawlaofficial]

Glad u liked it!!! Thanku so much..🙏🏻😊 Keep watching

[@VarunSrinivas]

wonderful video ma'am really helpful for a quick 1 hour revision of all my SQL concepts :)

[@SwatiChawlaofficial]

Thanku

[@lalithaprabhath6920]

Mam of a question arises like : DISPLAY DETAILS OF THOSE STUDENTS WHOSE NAMES ARE LESS THAN 5 CHARACTERS. What will be the query for the above question mam??? Mam, please provide answer USING LIKE OPERATOR and also USING NOT LIKE OPERATOR And Is it possible to write using the where clause or any other operators ?? If have please provide all answers mam which satisfy the given question

[@theseusswore]

15:35 this never made sense to me until now. i may be a different kind of stupid but jesus christ am i glad that i decided to watch your mysql playlist youve singlehandedly put me out of my sql anxiety. crystal clear and so intuitive! i disliked the syntax not being case-sensitive and what not but i actually get the intuitiveness of it now, as in, i would genuinely use mysql to manage and create databases if i were to have a need for one

[@SwatiChawlaofficial]

Thanks

[@unnatiesingh4320]

Thank you so much mam for this wonderful explanation 🙏🙏🙏🙏

[@SwatiChawlaofficial]

My pleasure 🙏🏻🙂

[@bantosingh7088]

Mam will you please give me a brief explanation of ESCAPE keyword with example?! Btw nice video mam!

[@shashank8933]

Mam if I want to search the record of any employee whose name contains 'a' anywhere then what will be the command?

[@SwatiChawlaofficial]

If u want to search for 'a' anywhere in a name, then use '%a%' But if you want to display thise names also which starts and ends with a also..then use or Operator.. %a% or a% or %a This will be the condition.. Syntax you can write..

[@shashank8933]

Thanks mam🙏

[@innovative2966]

Nice video thanks Ma'am

[@SwatiChawlaofficial]

Thanks for liking

[@sujalgupta8647]

Mam...Pls make a video on sql commands for multiple tables

[@SwatiChawlaofficial]

Check the Playlist.. it's already there.. Joins In MySQL Important Questions of MySql Commands..

[@neharikapuri7394]

amazing vedio mam!

[@SwatiChawlaofficial]

Thanku.... Keep watching....

[@alwayslolling8821]

print (“ crystal clear 💎 *100”)

[@anushkasharma9226]

Osm explainaition mam❤️❤️

[@SwatiChawlaofficial]

thanku..

[@ashishrathour3513]

Mam your explaination is awesome... How can i get these lecture notes?

[@SwatiChawlaofficial]

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

[@VardhanMittal]

Mam in syntax you are writing some word in capital letters .in exam we have to write in capital. Or we can write in small also

[@SwatiChawlaofficial]

It's a convention..u can write in small also...if u want

[@VardhanMittal]

@@SwatiChawlaofficial ok mam

[@yashboss9593]

Great video ma'am

[@SwatiChawlaofficial]

Thanks a lot

[@kushal6635]

Kassh aap meri school teacher hoti!! 👍

[@PriyanshuDhami-ch1sj]

Amazing mam❤️❤️

[@SwatiChawlaofficial]

Thanku...😊🙏🏻

[@utpalm9453]

Ma'am is there any difference between AND && , ?

[@adarshs9458]

Mam if we want to make a patern matching on integer data type column do we need to write the conditiom in quotes???

[@Shreyash_Mishra49]

karke dekh lo , beauty of maths and computer science

[@krishnanikhil2507]

Thank you mam loved it

[@SwatiChawlaofficial]

Thanks for liking

[@nidhilohia3944]

THANK YOU MAAM 🙏🙏🙏👌

[@SwatiChawlaofficial]

Welcome

[@sam-yx3yy]

In teligram can we get pdf of mysql lacture 🙏🏼???????

[@utpalm9453]

Ma'am.. is LIKE operator case sensitive???

[@SwatiChawlaofficial]

no

[@amareshswain7278]

Thank you ma'am 💖

[@SwatiChawlaofficial]

Welcome

[@RajveerSingh-pv4nd]

Sb clear 👍🏻

[@SwatiChawlaofficial]

Thanku

[@hansikagautam5437]

Wowwwww

[@SwatiChawlaofficial]

Thanku..

[@silent1975]

100th like😃😊 thank you mam

[@SwatiChawlaofficial]

Thanku....and Welcome 😊

[@silent1975]

Mam one request plz make vd on final practical program which will come in written practical exam and viva question

[@SwatiChawlaofficial]

@@silent1975 yes.. definitely..hope u watch today's live session.. Today i told about this..

[@silent1975]

@@SwatiChawlaofficial yes mam thank you😊

[@Menace0007]

Is it necessary to write like as LIKE ??

[@SwatiChawlaofficial]

No

[@krithash.v]

Mam can u please share us the written notes for every chapter.

[@SwatiChawlaofficial]

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

[@kartikeymalviya1768]

Please give the pdf of notes 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻

[@SwatiChawlaofficial]

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

[@lotus1413]

Mam what is the query to retrieve column names?

[@sandhyatiwari6168]

r u asking abt desc table command

[@indiranamasivayam9174]

Are pattern matching characters case sensitive or case insensitive mam

[@SwatiChawlaofficial]

case insensitive... like 'R%' and like 'r%' both will give you the same output...

[@studywithdivprit2744]

Mam i have a doubt !!!!!. In MySQL project line is that.,... If(platform.system() =="windows"): Print (os.system('cls')) else: Print (os.system('clear')) !!!!!! Mam plz explain this !!!!!

[@SwatiChawlaofficial]

used to clear the screen..depending on the type of operating system..

[@studywithdivprit2744]

Mam python idle screen ya... MySQL screen mam...clear karne ke liye h

[@studywithdivprit2744]

Thanks alot mam...aaj humara practical h

[@anushkasharma9226]

Mam I still have doubts in char and varchar ..pls make it clear to me🙏

[@SwatiChawlaofficial]

join today's live session @6:15 p.m. will explain in that...

[@ronitkumar4619]

Yeh Pattern Matching toh Permutation Combination se bhi zyada difficult tha

[@SwatiChawlaofficial]

No . It's easy..😅

[@ronitkumar4619]

@@SwatiChawlaofficial yes ma'am it's easy I got it after revision

[@SwatiChawlaofficial]

Great 😃

[@rohitnegi6990]

cleared!!!

[@SwatiChawlaofficial]

Thanku.. Keep Watching..

[@rishabhsharma7701]

superb mam

[@SwatiChawlaofficial]

Thank You..

[@saumyasingh...8441]

Thank you mam

[@SwatiChawlaofficial]

Thank you too

[@goutamsinghrajput5539]

Ma'am notes chahiye

[@SwatiChawlaofficial]

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

[@Sourab_kumar_]

😂😂

[@utpalm9453]

Is N% and n% same?

[@SwatiChawlaofficial]

yes..

[@scvlogs1070]

Tomorrow is my exam 😂😂😂

[@grasin404]

maam plz provide a pdf containing all commands and its use

[@SwatiChawlaofficial]

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

[@sujalkumar5011]

Mam can you please share PPT pdf it will be very helpful notes 😀

[@SwatiChawlaofficial]

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

[@Rekha10017]

Mam the playlist that now appears confuses me a lot. Earlier playlists which was divided in classes were easy to find😢😢 Mam please fix this issue 😭😭😭😭

[@SwatiChawlaofficial]

I think... This is KZbin's new update... I haven't changed anything... Please refer Home Tab of the Channel... You can find it there as well..

[@Rekha10017]

@@SwatiChawlaofficial sorry mam I commented about this issued on lot of your videos because I was really disturbed by this😢 So mam are you talking about the page where all the playlists appear in playlist section,,,, and I have to get it from there whatever I want to study???

[@starship3812]

Hoyegi

[@indersharma2022]

Mam I recommend you to buy a Pen/Stylus Instead of using mouse to write on the Screen...

[@SwatiChawlaofficial]

Thanks for your valuable suggestion and concern .... Already purchased.. now in my new videos... using digital pen tab..

[@Shreyash_Mishra49]

@@SwatiChawlaofficial maam can you please share the product link , or product name of digital pen/tab you purchased .... i know its bit off topic but still pls maam

[@rishabhsharma7701]

thank you mam for everything

[@SwatiChawlaofficial]

Welcome

[@indiranamasivayam9174]

Are pattern matching characters case sensitive or case insensitive mam

[@sync..]

✌️✌️✌️✌️✌️

[@sujalkumar5011]

Mam please provide pdf

[@SwatiChawlaofficial]

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

[@usye8802]

Thank you so much ma'aM

[@SwatiChawlaofficial]

Welcome

[@neharikapuri7394]

amazing vedio mam!

[@SwatiChawlaofficial]

Thanku....

[@Aves7]

Thanks mam

[@SwatiChawlaofficial]

Welcome

[@umamaheswarisrirengan8579]

Thank you mam

[@SwatiChawlaofficial]

Welcome

[@umamaheswarisrirengan8579]

Thank you mam

[@SwatiChawlaofficial]

Welcome

[@anchalsoni8982]

Thank you mam