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
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
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.
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
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?
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
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
@@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
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Bahot acchay say samjaya aapnay...thanks
Whenever I decide to learn any new Programming language, you're the first Tutor who comes in my mind ... 💯🙌🙏
Happy to hear that!
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 ...
very good yr,,, procedures ke opr bhi videos banao,,,os pr kisi ne achi videos nahi banai
I love the way you teaching us sir :)
Glad to hear that
Excellent ways of teaching great
Thanks for liking
Finished watching
4:35 selmon bhai idhar bhi fail ho gye........
Nice explanation...
you are the SQL CHAMP
Thanks and welcome
After your suggestion,watched this video at 1.5x speed and it felt very normal
👍😀
Nice explained.
Informative.
Awesome explanation sir
Thanks for liking
good stuff
Thank you ❤
superb teaching sir..
Thanks and welcome
Nice one
nice broooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Thanks :)
Nice Sir
great
Thanks
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
Set_safe_updates = 0
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
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
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
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.
@@YahooBaba Thank you sir
bro has serious issues with salman khan
superstar ko 3rd bata diya hahahaha lol just kidding kabhi heroin ke bhi naam likhen dekhne ke saath video sunne ka bhi sukun aayega
Haha jaroor 😄
salman khan ko fail kar deya bhai , app niklo kabi footpath pe aab.
😂😂
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.
Use the ALTER command to modify the existing table. See that video in this playlist.
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
Make video about pivoting.
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
You can access this database with any Server side language like PHP, NodeJS, Python and also with Javascript's fetch api or XMLHttpRequest.
@@YahooBaba Thank you very much
bhayi plzzz php pe ya vb pe logon system ka video banayen taaki saare ye commond use karne ka aur maza aaye
Mysql course ke bad main project banane wala hun aur Usi Mein login system bhi Si khaunga
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
Use the UPDATE command but without WHERE clause.
@@YahooBaba y without hwere clauses
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?
Yes it will work. Just give space between IN and round braces.
But you said else is compulsory then why you didn't add it in this query ?
Selmon bhai be like mujhe kyu toda
i think sir , indirectly hate Salman khan .... 🤣🤣🤣🤣🤣🤣🤣
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??
Use Cookies or Session variable for that.
@@YahooBaba thank you.
Sir php MySQL sikhne ke bad
Node js aur mongodb bhi sikni padegi kya
Nahi PHP ke baad NodeJS ke koi zaroorat nahi hai.
Can we create two foreign key in 1table..
Because I tried but it's not working , I think there is some mistake
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
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
Baba g ye or iske next wali videos important h?
can I found the already maken table from u
Yes get it from our website www.yahoobaba.net
@@YahooBaba thank u sir
Salman khan yha bhi fail ho gya😄😄😄
😂
Hope Salman Khan doesn't see this video 😂
😁😜
shaid kapoor ya pe bhi farzi wada kar raha hai
Can you please tell how to use loop in mysql
Loop in MySQL ? I don't understand what u want to ask. Can u explain what u exactly want to do ?
There's no use of loop in mysql
How to show only failed students
Salman khan fail kyu kar diya aapne
Codeigniter suro karo
Hello Abhi PHP Course mein Kafi Sare topics rahte hain jaise a oops, ajax, Jason. Inko cover ke bina codeigniter Shuru Nahin ho sakta.
Mai aa jau kya apni par?
Salman khan fail ho gaye hahahhahahahaha
😁
if else ?
salmon bhoi yha bhi fail 🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣🤣
😂
@@YahooBaba bhai tere hi video dekh rha hu 😂 my sql ka project nhi kerwaya yaar tune
Sab karwaya hua hai dear. See this playlist :
ruclips.net/p/PL0b6OzIxLPbzXPdt9pKeQXm6NoPA9MdKW
@@YahooBaba acha php me hai kya thanks bro 👍👍
Sir please PHP aur python ki practice ke liye koi website bataiye jisme dher saare example mil sake practice ke liye
Mukesh aise koi particular website toh mujhe nahi pata lekin agar aap google karoge toh kafi website aajati hai.
Ppt provide karaiye ya pdf iska
PPT toh mein share nahi karta hun lekin jald he sara content aapko humari website se miljayega
Salman khan fail 🥲🤣
khud ko fail karta salman khan ko q kar raha hai
Hahaha mere dost Logic pe dhayan do, salman khan ke chakkar mein logic na chod dena.
@@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