MySQL IF & CASE Statement Tutorial in Hindi / Urdu

[@udbhai786]

kia bat hai sir g ap pakistan k liay k bht kuch kryn gay wesy ap india say ho..mai nay ap k tuttorials daikh kr bht kuch seekha ...

[@dhavalpatel3455]

Bahot acchay say samjaya aapnay...thanks

[@sagarjain9444]

Whenever I decide to learn any new Programming language, you're the first Tutor who comes in my mind ... 💯🙌🙏

[@YahooBaba]

Happy to hear that!

[@azzadaamir7429]

very good yr,,, procedures ke opr bhi videos banao,,,os pr kisi ne achi videos nahi banai

[@dhruvrajsinhjadeja-vfxarti3085]

I love the way you teaching us sir :)

[@YahooBaba]

Glad to hear that

[@abdulnasirafridi]

Excellent ways of teaching great

[@YahooBaba]

Thanks for liking

[@manishkushwaha-je6xy]

4:35 selmon bhai idhar bhi fail ho gye........

[@gowtham171]

you are the SQL CHAMP

[@YahooBaba]

Thanks and welcome

[@SandipanSarkar-c8v]

Finished watching

[@RajeshKumar-dq8qr]

Nice explanation...

[@aakashsharma5901]

Awesome explanation sir

[@YahooBaba]

Thanks for liking

[@ankitshrivastava1772]

Nice explained.

[@akashpandey9796]

sir ak problem agar maine 2 table ko join kiya aur ak particular id for example id=1 show all data and id 2 hai to muje jitna data uske id se insert hua hai wahi dikhe

[@Abhay.Bhandari]

Informative.

[@Afzal883]

Sir how to write IF statement in sqldeveloper it is throwing error while I am typing with same syntax as yours Error is missing right parenthesis

[@rightorwrong7666]

12:34:09 update ifclause set persentage = (case id when 8 then 85 when 10 then 50 end) WHERE id in (8,10) Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.000 sec

[@Shivam-kz2dg]

Set_safe_updates = 0

[@simr4573]

Thank you ❤

[@harshdas7009]

Thanks

[@shockey3084]

good stuff

[@RajJaiswal538]

After your suggestion,watched this video at 1.5x speed and it felt very normal

[@YahooBaba]

👍😀

[@nitinmoon_Nagpur]

superb teaching sir..

[@YahooBaba]

Thanks and welcome

[@harshitashetty967]

Sir, I hav one query..regarding the case command wid update.. Update student SET percentage= ( Case WHEN id=3 THEN 39 WHEN id=7 THEN 62 End ) Where id IN(3,7) Will tis work?

[@YahooBaba]

Yes it will work. Just give space between IN and round braces.

[@sagarbhanage1832]

But you said else is compulsory then why you didn't add it in this query ?

[@junaidhassanmustafa4986]

Hi sir, can you please tell us how we can add foreign key constraint to existing column in table and add new column with foreign key constraint.

[@YahooBaba]

Use the ALTER command to modify the existing table. See that video in this playlist.

[@md.siddiq7165]

Hello sir. I have a question. suppose I created a table in mysql with some information. Can I access this table with frontend Javascript's fetch api or XMLHttpRequest ? or do i must have some backend code in php or node.js to access the database? I haven't learned backend yet that's why I'm confused. Hope you'll answer. Thank you

[@YahooBaba]

You can access this database with any Server side language like PHP, NodeJS, Python and also with Javascript's fetch api or XMLHttpRequest.

[@md.siddiq7165]

@@YahooBaba Thank you very much

[@HaiderAli-qv6rx]

Respected Sir, kiya ap bta sktay hai ky aik table sy 2 column ki values ko button ky click ky through next page py kesay bhej sktay hai??

[@YahooBaba]

Use Cookies or Session variable for that.

[@HaiderAli-qv6rx]

@@YahooBaba thank you.

[@faithxevents5013]

please sir explain me why id came with case. mene kayi logo ki videos dekhi hai but koi bhi is trh nhi smjata jis trh aap doubts clear krte ho

[@nilkanth5269]

Nice one

[@saharamanson1970]

nice broooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo

[@YahooBaba]

Thanks :)

[@webtutorials947]

sir mujhe bhi sikhna to aap mujhe tips dijiye naa ki 1 din me minimun kitne gante time dena chaiye web development sikhne ke liye

[@YahooBaba]

Dekho dost ghante ginane ki jaroorat nahi hai bus aapka har course ka Time Target rakho ki jaise HTML CSS mujhe 1 Month mein complete karni hi karni hai. Aisa karoge toh practice hours apne aap badh jayeinge. Aapne dekha bhi hoga hum exam wale dino mein jyada kaise pad paate hai kyu ki wha hume LIMITED Time dikh rha hota hai ..... aur us Limited time mein bhi hum kitna kuch kar lete hai. Isliye jab bhi kisi Field mein kamyab hona hai toh aapne aapko ek ORDER do ki kuch bhi ho mujhe Itne TIME mein ye kaam karna hi karna hai. Aur mera suggestion hai ki jo bhi video se seekhte ho uski practice jaroor karo nahi toh wo topic kuch hi din mein bhool jaoge.

[@webtutorials947]

@@YahooBaba Thank you sir

[@ankitparashar8730]

Sir php MySQL sikhne ke bad Node js aur mongodb bhi sikni padegi kya

[@YahooBaba]

Nahi PHP ke baad NodeJS ke koi zaroorat nahi hai.

[@akSingh_120]

great

[@deepanshidhingra]

Hey . How to add values to newly added column in the table . I have to add all the values together not one by one . Struggling to do this

[@YahooBaba]

Use the UPDATE command but without WHERE clause.

[@zaib5263]

@@YahooBaba y without hwere clauses

[@shabeeb4002]

salman khan ko fail kar deya bhai , app niklo kabi footpath pe aab.

[@RohitYadav-lq7ly]

😂😂

[@Nishant12375]

Baba g ye or iske next wali videos important h?

[@JustForProgrammers]

Nice Sir

[@niftyboss534]

bhayi plzzz php pe ya vb pe logon system ka video banayen taaki saare ye commond use karne ka aur maza aaye

[@YahooBaba]

Mysql course ke bad main project banane wala hun aur Usi Mein login system bhi Si khaunga

[@niftyboss534]

superstar ko 3rd bata diya hahahaha lol just kidding kabhi heroin ke bhi naam likhen dekhne ke saath video sunne ka bhi sukun aayega

[@YahooBaba]

Haha jaroor 😄

[@AnujGupta-kw9sw]

Can we create two foreign key in 1table.. Because I tried but it's not working , I think there is some mistake

[@YahooBaba]

Hello Anuj, their is no need to create two foreign keys because even not making a single foreign key we can join more than 2 tables with SQL JOIN, Left JOIN, Right JOIN commands.I taught you about foreign key just for education purpose.But if u still want to make 2 foreign keys in one table then follow this link : dev.mysql.com/doc/refman/5.5/en/create-table-foreign-keys.html

[@niftyboss534]

sir line kayi text box liye sab main value bhari ab ham chahate hain ki 1st text box ki value ko leke dekhe ki niche ke agar kisi bhi text box ki valuse choi hai to uska fore color badal jaye aise hi text box 2 apne se niiche ke box ki valu chek kar kisi bhi text box ki valu agar niche ke text box ki valuse se badi hai to vo text box blannk ho jaye choota sa program bana de koi bache ke liye plzzz

[@saurabhchaudhary3333]

Make video about pivoting.

[@commenter19988]

bro has serious issues with salman khan

[@vinaymishra8533]

can I found the already maken table from u

[@YahooBaba]

Yes get it from our website www.yahoobaba.net

[@vinaymishra8533]

@@YahooBaba thank u sir

[@ritikagupta4403]

Can you please tell how to use loop in mysql

[@YahooBaba]

Loop in MySQL ? I don't understand what u want to ask. Can u explain what u exactly want to do ?

[@mrsprite399]

There's no use of loop in mysql

[@puneetsrivastava9764]

shaid kapoor ya pe bhi farzi wada kar raha hai

[@tejasbhor3261]

Selmon bhai be like mujhe kyu toda

[@flash2702]

Mai aa jau kya apni par?

[@mukeshkumarverma8021]

Sir please PHP aur python ki practice ke liye koi website bataiye jisme dher saare example mil sake practice ke liye

[@YahooBaba]

Mukesh aise koi particular website toh mujhe nahi pata lekin agar aap google karoge toh kafi website aajati hai.

[@ExternalAffairsprikus]

i think sir , indirectly hate Salman khan .... 🤣🤣🤣🤣🤣🤣🤣

[@hamidansari9331]

Ppt provide karaiye ya pdf iska

[@YahooBaba]

PPT toh mein share nahi karta hun lekin jald he sara content aapko humari website se miljayega

[@urbanpenduz5891]

How to show only failed students

[@vj0904]

if else ?

[@funshowsdh1yl]

Salman khan yha bhi fail ho gya😄😄😄

[@YahooBaba]

😂

[@reaction1340]

Codeigniter suro karo

[@YahooBaba]

Hello Abhi PHP Course mein Kafi Sare topics rahte hain jaise a oops, ajax, Jason. Inko cover ke bina codeigniter Shuru Nahin ho sakta.

[@mathsloverankit416]

Salman khan fail kyu kar diya aapne

[@moshahid8257]

Salman khan fail ho gaye hahahhahahahaha

[@YahooBaba]

😁

[@prafulrane3591]

Hope Salman Khan doesn't see this video 😂

[@YahooBaba]

😁😜

[@anshulbhati4439]

salmon bhoi yha bhi fail 🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣

[@YahooBaba]

😂

[@anshulbhati4439]

@@YahooBaba bhai tere hi video dekh rha hu 😂 my sql ka project nhi kerwaya yaar tune

[@YahooBaba]

Sab karwaya hua hai dear. See this playlist : kzbin.info/aero/PL0b6OzIxLPbzXPdt9pKeQXm6NoPA9MdKW

[@anshulbhati4439]

@@YahooBaba acha php me hai kya thanks bro 👍👍

[@jaydeeppapmpaniya]

Salman khan fail 🥲🤣

[@ghulammehdisoomro7980]

khud ko fail karta salman khan ko q kar raha hai

[@YahooBaba]

Hahaha mere dost Logic pe dhayan do, salman khan ke chakkar mein logic na chod dena.

[@ghulammehdisoomro7980]

@@YahooBabaMain Salman khan ka bhot bara fun ho is lie mani ke dia mojhai maf karna.app is ki jaga koch aur kar deti .app ki logic bhot zaberdest hoti hai