MySQL COMMIT & ROLLBACK Tutorial in Hindi / Urdu
HTML-код
- Опубликовано: 17 окт 2024
- In this tutorial you will learn mysql commit and rollback tutorial in Hindi, Urdu.You can learn what is commit and rollback in sql and how to use it to revert updated or deleted data from data tables in mysql database 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
babaji great explanation trully goes to my mind thank you for your efforts.
Sir iskay baad java ka tutorial baniyega,aap bahut accha samjhtay hai, menay apki videos say 2 weeks may hi HTML,css3, jquery, JavaScript sikhli hai or php sikh raha hu,
Thank u sir for making this kind of helpful videos.puray RUclips may apkay jitna accha koi nhi samajhta hai.
Hello Shiva thanks for appreciating my work. Dekho Java ka abhi koi plan nahi hai aur na hi next year. Abhi PHP course chal rha hai aur uske baad Codeigniter, Laravel, Advance Javascript, ReactJS, AngularJS ke course aayenge. Java se related youtube par already bhut se courses pade hai toh aap kahi se bhi kar sakte hain.
Sir can you make vedio on normalisation and types of keys
Bahut pareshan lag rahe ho😄
Yes sir we need
❤
sir 4th button jo is video me ap ny use kiya ha matlb execute button k sath wala...ye phpmyadmin me kis name sy available hoga? q k me phpmyadmin me practice kr rha hun..
sir aap jis simplicity se padate ho bo gajjab hai
Aise kaun rolback krta h?? Rollback condition ke basis pr hoga na..ya sidhe rollback krdoge??
Sir, in mine the roll back is not working...I did ROLLBACK; but still it shows the new data in the database....I have unchecked that auto commit box which u told in the video in start
yes the same thing is happening with me
BEST CHANNEL TO STUDY SQL
Sir mera aik question hy.
Misal k tor p main ny 50 different values update/insert kr di hain 1 hi dfa main lakin last 5 values galt update/insert ho gaen.
abhi main commit use ni kiya ku k main 50 values k bad krna chah rha tha iska koe solution bta dein kindly.
Mistake hoty pta ni chlta k kab galat data insert ho jana tu is problem ko kesy handle kiya ja skta hy?
Sir jo xampp server use krte hain wo kia karen?
Thank you so much Sir for this amazing Explanation😍
Thank you sir
Apki pdhane ki technique bhut achhi h
Thanks and welcome :)
Thanku 😊
hello sir i am on your css tutorial now and i have a question . Is it normal to forget tags and other things while making a website and to watch tutorial again beacuse i forget all these things after 2 or 3 days
Hello usman, to memorize html tags and css you have to make some templates. By making templates is the only way to become master of css.
Ekdum samj gaya thankyou sir ❤
Thanks so much, this was outstanding
Sir what is the difference between unique and distinct ?? Please reply me.
Sir agar pura database delete ho gaya ho to usko kese Undo karte hai?
Should we use commit command every time before creating table? Hame pata nahi hoga na ham kab galti karenge. To kya hame harbar use karna hoga commit?
Dekhiye iska use karna compulsory nahi hai. Main khud MySQL 17years se use kar rha hun aur maine personally kabhi iska use nahi kiya hai.
Thanks sir💐
Also explain save point cmd
hello sir , sir mera work ni kr rha , acutally affected aa rha hai , but kuch rollback ni rha
Sir COMMIT & ROLLBACK xampp pe keise practice karta he is lekar 1 video banate to accha hota
Sir Mai data base ke sql editor me kar raha hu usme
commit;
Or
Rollback;
nahi chal raha hi
Data base me kaise commit command ko uncheck kare please give me solution....
good teaching skill level thank you somuch for better teach
Thanks and welcome :)
Dear Sir!
When I directly truncate the table from the database, after this the PHP scripts show unexpected behavior. How to use RollBack here after truncating the table to avoid PHP unexpected behavior.
Love from Pakistan.
Thank you so much, sir!
use EaseUS MS SQL Recovery Software when you accidently delete or truncate the table.
Thank you sir very good explanation ❤
Most welcome
Great explained
Thanks for this video sir :)
Very helpful 👍 thanks 😊
Finished watching
amazing explanation
Sir can you please explain union, union all sub queries, and all types of joins.
Thank you sir ❤️🙏🏻
Hii sir my question is.... rollback work in delete function....yes or no
No, the ROLLBACK command does not directly affect the DELETE function in SQL.
Sir transaction ka video nai hai or savepoint ka bhi. @Yahoo Baba reply kar doo😒😒
sir php Myadmin me yeh option kaha hai commit wala ?
Well explained
Thank you very much sir, appreciate your help. keep up the good work
You are welcome
Thanks sir 😇😇😇😊😊😊😊
Hi Sir, I want to update two table in single query .......is that possible? if yes please tell me how........because i want update two tables at same time
You can't update two tables in single query.
Sir, I am pursuing BCA ,, so can I be a Web Developer with this degree. I mean this bachelor degree is enough for web developer
Anuj I am also a BCA Graduate. I have completed my graduation in 2004. In that time BCA was not in demand Still I have worked with 4 Multinational companies as a web developer. Now a days BCA is equivalent to Btech. My two students of BCA got their first job in Infosys just a month a before. So don't worry at all. Even some students with 12th class trained by me now working as a Web Developer. Bill Gates , Mark Zuckerberg, Steve Jobs have no Btech degree but they create world's no. 1 software , social networking and Phone companies.So just focus on what u like and passion.
@@YahooBaba I am very thankful to you sirji... That u made me out of this confusion.. 🙏
But according to you what are the main things that we have to be sure to be a web developer...
Thanks you sir
Your welcome :)
Great thanks sir ❤️
Most welcome
EXCELLENT SIR !! THANKS A LOT
Most welcome!
@@YahooBaba By default autocommit on ya off hota hai?
@@ADITYA-bd8mu on hota h
Thnx for best videos
Most welcome
thanks_Sir💜
Good
ROLLBACK AND COMMIT not run in wamp server ..... what is setting in wamp server?
Sir Kindly is month ma SQL khatam karan and next month 2020 sa pehla PHP and Laravel, Laravel ki muja zarurat ha PLease?
Laravel se pehle aapko koi aur framework aata hai jaise Codeigniter etc. Because Laravel directly aapko itna samajh nahi aayega aur shayad mushkil bhi lagega. Pehle aapko koi easy MVC Framework seekhna hoga like Codeigniter.
@@YahooBaba Ohh Framework, mtlb muja Wordpress pehla sekhna ho ga?
Tho fida kiya ho ga is ka? kindly thora explain kar dan
Umer wordpress framework nahi hai.... Wo ek CMS hai (content management system). Mein MVC framework ki baat kar rha hun.
@@YahooBaba Acha sir.
@@YahooBaba Sir Hama Wordpress kub sekna chahiya?
Sir ma jub *COMMIT* and *RoLLBACK* use karta hon tho mara pas table *update* nahi hota Q?
Koe errors be nahi ha!
CODE:
commit;
update person
set age = 10;
rollback;
Rollback karne se table update nahi hoga ..... bus last changes jo table mein hue honge wo revert ho jayenge. Yha jo aapne (age=10) set kiya hai sari ROWS ka wo dubara se wahi ho jayega jo pehle tha.
And make sure ki aapne Edit Menu > Preferences > SQL Execution > (New connections use auto commit mode ) ko uncheck kardiya hai.
@@YahooBaba Kiya ha sir.
nice
What is storage engine
sir ye rollback phpmyadmin pern work nahi kar rahi hai
Sir grant and revoked ka bhi video nai hai .reply kar na sir
I will make it next month
sir..why do we use XAMPP server...what is its role...i'm unable to understand...plz can anyone explain this to me........!!!!!!!!!!
Actually I made this course for PHP developers and for PHP we need local server. We use Xampp as a local server for PHP development and MySQL.
If you are not planning to learn PHP then you don't need to install Xampp server, here you can use "MySQL Server" to learn MySQL.
Sir facing problem on rollback
I'm not getting previous data
Please sir help me out of this problem
WORKBENCH use kar rahe ho to bandh karke firse open karo..
hi, use SET autocommit = 0; in the first line of code, hopefully you would get what you want
thanks sir
Most welcome
Sir rollback is showing a warning " Some non-transactional changed tables couldn't be rolled back "
AUTOCOMMIT OFF KER DO
Delete can be rollback, How❓
How to do this in phpmyadmin?
commit and rollback doesnt work sir.. i tried evry single line but in output area i see " 0 rows affected". no changes id done after commit or rollback.. i dont understand this problem.. is there any changes in setting of mysql?
BRO XAMPP SERVER ON KAR K GooGLE PAR LOCAL HOST TYPE KARO WAHA PHP MY ADMIN MAIN JAKAR YAHI UPDATE COMMAND TYPE KARO WAHA TUMAY SHOW HOTAY DIKH JAEGA MERAY SATH BHI YAHI MASLA HAI PAR ABHI FILHAAL TW YAHI SOLUTION HAI WAHA SHOW HORAHA HAI.........
agr waha pr bh samjh na aye tw fb pr contact karlo waha samjha dunga facebook.com/profile.php?id=100053722793422
same issue i m facing , if u have any solution , pls tell me
Mera me rollback nhi ho rha h
Mera Rollback ni hua...
Here we got know salman khan salary.
update command not working ....
paste your command here. I will check it.
mayra rollback nhi ho raha
Wecube yeha se video copy kiya
Wo sab to thik hai lekin jiss table me Example dete ho usi me task kyun nai perform karte jayda achhe se samajh aayega
ROLL BACK = UNDO
drive.google.com/file/d/100bWQH7OXN916qSTnYLPClnr3ui7qk1h/view?usp=drivesdk
Sir mera roll kam nhi kr rha ..
Ye wala bilkul nai samjha
Sir, in mine the roll back is not working...I did ROLLBACK; but still it shows the new data in the database....I have unchecked that auto commit box which u told in the video in start
yeah, same happening with me, do you get the resolution?
Same problem 😕
same problem
Thank you sir . very well explained👌👌
You're most welcome
Thank you sir👌👌clear
Welcome 👍
thankyou sir..
Most welcome
Well explained