MySQL UPDATE Tutorial in Hindi / Urdu
HTML-код
- Опубликовано: 18 ноя 2019
- In this tutorial you will learn mysql update command tutorial in Hindi, Urdu.You can learn how to update database table data with SQL update command in hindi.
PHP Tutorial in Hindi Playlist
• ✅ PHP Tutorial in Hind...
MySQL Tutorial in Hindi / Urdu Playlist
• 🥇 MySQL Tutorial for B...
Official Website
www.yahoobaba.net/
Follow us on Facebook
/ yahooobaba
Follow us on Twitter
/ yahooobaba
#mysql #webdevelopment #php
best tutorial ever. thanks sir.
many many thanks sir
Thank You..
Thanks you so much sir.. aap bahot acche se teach karte hai..even maine puri web development aap se hi sikhi hai ☺️ ... thanks u so much again
Your welcome :)
I am form Bangladesh.This tutorial is the best .Thanks Yahoo BABA
You are most welcome
Thanks 🔥
Sir bahut bahut dhanyavaad.... Aapke kadam choomne ka dil karta hai
Aila 🙄
thanks_sir💜
Great teacher.
Glad you think so!
very helpful video sir
Thanks and welcome
awesome
Thanks a Million
thanks sir awesome video 😊😊😊😊
Most welcome
nice explanation keep it .
try to make some videos combined with php and mysql like signup/login adminpanle startup and so on.
Yes sure, After MySQL course i will make 2 projects on PHP with MySQL.
@@YahooBabaBaba amazing this is good for learning web development also uses ajax and jquery in those projects.
thanks a lot.
Most welcome!
Nice explanation sir❤
Thanks and welcome
Sir how to add new column in same table that was already created ?
Sir plz reply with complete query.
Nice
Sir, Agar hm alter command se ek new column add krte hai kisi table me then uss new column me data kis command se bhr skte hai .
Please reply Sir
You're my all time favourite 🥰
Good
Very good sir
Thanks :)
Sir please make live project like ecommerce website
Sir bht bht bht helpful videos hain plz php or mysql pr ak complete project b bana dain
MySQL course ke baad project aane hi wala hai.
@@YahooBaba thank you sir!!!!!!!!!!!!!!!!
Good luck
Sir koi esa option h jisse duplicate record insert n ho datatable me
Awesome tutorial :)
Thanks Umer :)
Sir thanks for your videos firstly.and i have one doubt , what if we want to update 3 columns with different values??
Can we do it in single query or we have to write this query 3 times??
To update 3 columns just use single query.
@@YahooBaba how sir ??
@@shrutikadhabale937 He has already showed @ 5:00
Sir, Agar hm alter command se ek new column add krte hai kisi table me then uss new column me data kis command se bhr skte hai .
Please reply Sir
You're my all time favourite 🥰
sir its possible k har id pe different values update kre sake ek hi command se?
Update product set price = 60,55,45,115,370 where P_id = P001, P002, P003, P004, P005;
Sir alag alag age ek baar me multiple rows me update kr rha hu tobhi ek hi age dono me dikha de rha hai jo aapne 6.44 sec pr kiya hai
Waha agar set age =18,age=19
Krne pr bhi keval 18 hi dono me update ho ja rha hai aisa kyu
Sir muje ko header mey spell thik krni hai Example- Pone to Phone ???
Sir multiple IDs me multiple values update Karni ho to kese Karen?
This is my doubt also bro if u got it please share 🙏
For the last query which you're doing without where clause.its not working in my server it shows error that you are using safe update mode and you try 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. I don't know what to do if anyone knows please tell me
Dear aapke MySQL WorkBench ka Safe Mode enable hai. Usse preferences mein ja kar Disable kar do.
Sir Angular Js Video Bana Kab Start Karoge......!
Next year 2020
Can we update Id 2's percentage and id 3's age in single line command?
No
Sir wo kehte hain safe update made ko disabled kro ab kia kron
Sir,i am doing like this but it shows error...why sir??
set percentage = 95
where age = 25 ;
This man literally obsessed with salaman khan.
😂
Agar hmne Galti se Sare records ko change Kar diya to usko undo kr skte hai hm ?
Nahi aisa nahi kar sakte
Sir mane mane apni data table me salery ka column nhi bnaya he or mujhe ab add krna he salary ka column usi table me to kase hoga...
Uske liye aapko SQL ki Alter command ka use karna hoga.
Hello sir . I hope you doing well . Sir agar humay pata na ho k jo column ma hum work kr rahay ha uski data type kya ha so tub hum kya kray ga ?Thank you
Dear salman aisa kabhi nahi hota, Kyu ki jo developer code kar rha hota hai wahi database ka structure bhi banata hai.
@@YahooBaba Thank you sir . Menay apko email kri ha ek please uska laxmi response krday about Native and Hybrid aaps
Kya bina xampp server ke MySQL workbench use nhi kr skte h kya
no
Ho sakta hai, lekin uske liye aapko pehle MySQL install karna hoga. Please follow this link : www.mysql.com/downloads/
@@YahooBaba thank you very much sir 🙏
Sir please demonstrate Ajax with pagination and json... I have trouble in these topic I'm working on project and I'm not getting any proper solution for these.
Ajax with Pagination mein issi PHP course mein karunga lekin abhi thoda time lagega ..... may be 20 days.
@@YahooBaba till then what should I do now please give me any solution.
@@chaitanyadusane2272 Please follow other videos of another channel for your solution or you can search on google for the solution.
Sir coloum name to delte krne k liye kya use krenge
Uske liye ALTER command use hoti hai, Isi course mein uska bhi video hai
🙂
sir can we change data through name column but not id column ??
Yes we can but keep remember that some people have same name, so if you update with name column then by mistake we can update all records with same name.
How to fill null value
If I run this code I got error like 'your are using safe updated' Then what should I do ?
See this article for that : stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench
You have to run this command :
SET SQL_SAFE_UPDATES = 0;
Sir id ke badle name likhkar update nahi kar sakte
Bilkul kar sakte hai lekin agar same name kahi persons ka hoga toh sabhi jagha update ho jayega.
*Bhai....Kya mysql database Mai paragraph add kr sakte hai...aur yes ho to kaise plz* help
Yes kar sakte hai uske liye aapko Column ki datatype "text" leni hogi
@@YahooBaba haa..Bhai...Maine leli hai...data type text ...
But every time when I give line break for paragraph that time new double row createed...I want 1 paragraph in 1 row ...plz any solution....plz Bhai...plzzz
Yes this is the way it works. Actaully we use MySQL with any server side programming language like PHP, Python etc. and for different paragraphs we uses "" tag of HTML.
@@YahooBaba okyee....bro thank you so much ...I will try it...and tysm for replying...🤩
Salman khan salary ☠️☠️☠️
Sir update function kisi table mein thik kmm kr rha h aur kisi table mein nahi
Aisa nahi hota hai. Aapke UPDATE command mein error hoga.
Hellow sir.yaha aik Error araha jo solve b ni horahi hy.
Error code:you are using safe mode and you tried to update a table without a where that uses a key column to disable safe mode,toggle the option is preference.
Kindly reply me i have completed HTML ,CSS,PHP from your tutorial now My SQL is progress.
Follow the following steps before executing the UPDATE command: In MySQL Workbench
1.Go to Edit --> Preferences
2.Click "SQL Editor"
tab and uncheck "Safe Updates" check box
3.Query --> Reconnect to Server // logout and then login
4.Now execute your SQL query
Thank you sir ..ALLAH apko kamyab kary..
Waoo sir it works.i have solved my problem bcs of you.sir i have learnt alot of things from and in university is just waisting of time on theory and ratta.i'll never forget your this kindness.May you success in your life.
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
Why this error is showing? I used the WHERE clause as your instruction. How to solve it?
Steps to solve this problem :
1.Go to edit
2. Click on preferences
3. Click on sql editor
4. At the bottom of this page u will find a check box (safe updates) , uncheck it
5. Restart ur mysql
@@swaggerji3531 thanks❤
sir there is an error 1451 kindly guide
Can u tell me in detail what is ur command and table structure.
Dear Sir How to Become a IOS App Developer Basic to Advence......! Reply
Just run this sql ... thank me later
SET SQL_SAFE_UPDATES = 0;
Change the channel name, atleast 10% subscriber will be increased
My purpose of this channel is to teach free of cost. I am not here to increase subscriber and make money. But thanks for your suggestion.
@Yahoo Baba, I am wasting your time, but can you please tell me why you chose this title if you didn't intend to make money from youtube?
Actually I was looking for unique name, so I select two popular websites "Yahoo" and "Ali Baba" then I removed Ali and combine Yahoo Baba... so simple 😀
@Yahoo Baba :)) Thank you sir for giving such great content for free. I am in 2nd year studying CSE. Your content is truly unique. I am enjoying your content very much. Last day one of my friends asked about the source of PHP but I was unable to tell your channel name. It was so embarrassing for me to tell "I am studying from Yahoo Baba". That is why I told you to change your channel name.