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

Комментарии • 130

  • @futuremillionairetrader6841
    @futuremillionairetrader6841 Год назад +4

    babaji great explanation trully goes to my mind thank you for your efforts.

  • @shivakashyap8695
    @shivakashyap8695 4 года назад +1

    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.

    • @YahooBaba
      @YahooBaba  4 года назад

      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.

  • @sampadagunjal9313
    @sampadagunjal9313 3 года назад +20

    Sir can you make vedio on normalisation and types of keys

  • @talhasajid7320
    @talhasajid7320 3 года назад +1

    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..

  • @katw434
    @katw434 Год назад

    sir aap jis simplicity se padate ho bo gajjab hai

  •  2 года назад

    Aise kaun rolback krta h?? Rollback condition ke basis pr hoga na..ya sidhe rollback krdoge??

  • @CreativeSamCS
    @CreativeSamCS 2 года назад +3

    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

  • @priyanshagupta9643
    @priyanshagupta9643 Год назад

    BEST CHANNEL TO STUDY SQL

  • @usamanadeem145
    @usamanadeem145 3 года назад

    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?

  • @syedshahwaiz4876
    @syedshahwaiz4876 10 месяцев назад

    Sir jo xampp server use krte hain wo kia karen?

  • @ankurpathak-2373
    @ankurpathak-2373 2 года назад +1

    Thank you so much Sir for this amazing Explanation😍

  • @minchanal2404
    @minchanal2404 Год назад

    Thank you sir
    Apki pdhane ki technique bhut achhi h

  • @premshankarsaini5375
    @premshankarsaini5375 21 день назад +1

    Thanku 😊

  • @usmanabdullah8454
    @usmanabdullah8454 4 года назад +3

    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

    • @YahooBaba
      @YahooBaba  4 года назад +2

      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.

  • @Khushi-FoodPlaza
    @Khushi-FoodPlaza 3 месяца назад

    Ekdum samj gaya thankyou sir ❤

  • @jatinnandwani6678
    @jatinnandwani6678 5 месяцев назад

    Thanks so much, this was outstanding

  • @AbantikaNayak-j6c
    @AbantikaNayak-j6c 5 месяцев назад

    Sir what is the difference between unique and distinct ?? Please reply me.

  • @hellopeter6061
    @hellopeter6061 3 года назад +4

    Sir agar pura database delete ho gaya ho to usko kese Undo karte hai?

  • @abhishek_67
    @abhishek_67 2 года назад

    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?

    • @YahooBaba
      @YahooBaba  2 года назад

      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.

  • @ashishmehrotra7308
    @ashishmehrotra7308 2 года назад

    Thanks sir💐
    Also explain save point cmd

  • @harmanpreetkaur8926
    @harmanpreetkaur8926 3 года назад +1

    hello sir , sir mera work ni kr rha , acutally affected aa rha hai , but kuch rollback ni rha

  • @mdhabiburrahman4231
    @mdhabiburrahman4231 4 года назад

    Sir COMMIT & ROLLBACK xampp pe keise practice karta he is lekar 1 video banate to accha hota

  • @anshumaantiwari3273
    @anshumaantiwari3273 2 года назад

    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....

  • @jitendramahule6438
    @jitendramahule6438 2 года назад

    good teaching skill level thank you somuch for better teach

    • @YahooBaba
      @YahooBaba  2 года назад

      Thanks and welcome :)

  • @Muhammad_Naeem662
    @Muhammad_Naeem662 10 месяцев назад

    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!

    • @Its_Fakhir_Ali
      @Its_Fakhir_Ali 8 месяцев назад

      use EaseUS MS SQL Recovery Software when you accidently delete or truncate the table.

  • @PatialaKing-up2te
    @PatialaKing-up2te 5 месяцев назад

    Thank you sir very good explanation ❤

    • @YahooBaba
      @YahooBaba  5 месяцев назад +1

      Most welcome

  • @shahzaibidreesahmed4827
    @shahzaibidreesahmed4827 10 месяцев назад

    Great explained

  • @dhruvrajsinhjadeja-vfxarti3085
    @dhruvrajsinhjadeja-vfxarti3085 4 года назад +1

    Thanks for this video sir :)

  • @roshniaslam8148
    @roshniaslam8148 2 года назад

    Very helpful 👍 thanks 😊

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 5 месяцев назад

    Finished watching

  • @InfinteMotivation
    @InfinteMotivation Год назад

    amazing explanation

  • @mohammadumair5312
    @mohammadumair5312 3 года назад +1

    Sir can you please explain union, union all sub queries, and all types of joins.

  • @adityakori70
    @adityakori70 Год назад

    Thank you sir ❤️🙏🏻

  • @deepakkumar3301
    @deepakkumar3301 2 года назад

    Hii sir my question is.... rollback work in delete function....yes or no

    • @Muhammad_Naeem662
      @Muhammad_Naeem662 Год назад

      No, the ROLLBACK command does not directly affect the DELETE function in SQL.

  • @mananbhimani3979
    @mananbhimani3979 4 года назад

    Sir transaction ka video nai hai or savepoint ka bhi. @Yahoo Baba reply kar doo😒😒

  • @faisalmalik4988
    @faisalmalik4988 4 года назад +2

    sir php Myadmin me yeh option kaha hai commit wala ?

  • @kingsrahman7208
    @kingsrahman7208 Год назад

    Well explained

  • @utpalmohane1416
    @utpalmohane1416 2 года назад

    Thank you very much sir, appreciate your help. keep up the good work

  • @bhagirathiverma2627
    @bhagirathiverma2627 Год назад

    Thanks sir 😇😇😇😊😊😊😊

  • @vinayakharade9283
    @vinayakharade9283 4 года назад

    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

    • @YahooBaba
      @YahooBaba  4 года назад +1

      You can't update two tables in single query.

  • @AnujGupta-kw9sw
    @AnujGupta-kw9sw 4 года назад +1

    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

    • @YahooBaba
      @YahooBaba  4 года назад +7

      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.

    • @AnujGupta-kw9sw
      @AnujGupta-kw9sw 4 года назад +1

      @@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...

  • @BackboneofTechno
    @BackboneofTechno 4 года назад +2

    Thanks you sir

  • @tabrez_zeta
    @tabrez_zeta 3 года назад +1

    Great thanks sir ❤️

  • @sakshamsharma3156
    @sakshamsharma3156 3 года назад +1

    EXCELLENT SIR !! THANKS A LOT

    • @YahooBaba
      @YahooBaba  3 года назад

      Most welcome!

    • @ADITYA-bd8mu
      @ADITYA-bd8mu 2 года назад

      @@YahooBaba By default autocommit on ya off hota hai?

    • @zishamalik3500
      @zishamalik3500 2 года назад

      @@ADITYA-bd8mu on hota h

  • @zaib5263
    @zaib5263 4 года назад

    Thnx for best videos

  • @Sans_K5
    @Sans_K5 2 года назад

    thanks_Sir💜

  • @safiawali78
    @safiawali78 Год назад

    Good

  • @oxforddictionaryvocab2715
    @oxforddictionaryvocab2715 6 месяцев назад

    ROLLBACK AND COMMIT not run in wamp server ..... what is setting in wamp server?

  • @iUmerFarooq
    @iUmerFarooq 4 года назад

    Sir Kindly is month ma SQL khatam karan and next month 2020 sa pehla PHP and Laravel, Laravel ki muja zarurat ha PLease?

    • @YahooBaba
      @YahooBaba  4 года назад +1

      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.

    • @iUmerFarooq
      @iUmerFarooq 4 года назад

      @@YahooBaba Ohh Framework, mtlb muja Wordpress pehla sekhna ho ga?
      Tho fida kiya ho ga is ka? kindly thora explain kar dan

    • @YahooBaba
      @YahooBaba  4 года назад +1

      Umer wordpress framework nahi hai.... Wo ek CMS hai (content management system). Mein MVC framework ki baat kar rha hun.

    • @iUmerFarooq
      @iUmerFarooq 4 года назад

      @@YahooBaba Acha sir.

    • @iUmerFarooq
      @iUmerFarooq 4 года назад

      @@YahooBaba Sir Hama Wordpress kub sekna chahiya?

  • @iUmerFarooq
    @iUmerFarooq 4 года назад

    Sir ma jub *COMMIT* and *RoLLBACK* use karta hon tho mara pas table *update* nahi hota Q?
    Koe errors be nahi ha!

    • @iUmerFarooq
      @iUmerFarooq 4 года назад

      CODE:
      commit;
      update person
      set age = 10;
      rollback;

    • @YahooBaba
      @YahooBaba  4 года назад +1

      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.

    • @YahooBaba
      @YahooBaba  4 года назад +1

      And make sure ki aapne Edit Menu > Preferences > SQL Execution > (New connections use auto commit mode ) ko uncheck kardiya hai.

    • @iUmerFarooq
      @iUmerFarooq 4 года назад

      @@YahooBaba Kiya ha sir.

  • @akSingh_120
    @akSingh_120 Год назад

    nice

  • @classifybazaar365
    @classifybazaar365 Год назад

    What is storage engine

  • @Rehan_Official121
    @Rehan_Official121 Год назад

    sir ye rollback phpmyadmin pern work nahi kar rahi hai

  • @mananbhimani3979
    @mananbhimani3979 4 года назад

    Sir grant and revoked ka bhi video nai hai .reply kar na sir

    • @YahooBaba
      @YahooBaba  4 года назад

      I will make it next month

  • @abhi-pz1dl
    @abhi-pz1dl Год назад

    sir..why do we use XAMPP server...what is its role...i'm unable to understand...plz can anyone explain this to me........!!!!!!!!!!

    • @YahooBaba
      @YahooBaba  Год назад

      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.

  • @maheshbidarkar600
    @maheshbidarkar600 2 года назад

    Sir facing problem on rollback
    I'm not getting previous data

    • @maheshbidarkar600
      @maheshbidarkar600 2 года назад

      Please sir help me out of this problem

    • @Harshpatel-hs9gz
      @Harshpatel-hs9gz 2 года назад

      WORKBENCH use kar rahe ho to bandh karke firse open karo..

    • @danishhaider101
      @danishhaider101 Месяц назад

      hi, use SET autocommit = 0; in the first line of code, hopefully you would get what you want

  • @techboy4328
    @techboy4328 3 года назад

    thanks sir

  • @mayankkumawat6869
    @mayankkumawat6869 4 года назад

    Sir rollback is showing a warning " Some non-transactional changed tables couldn't be rolled back "

  • @chaudharyashisharun1581
    @chaudharyashisharun1581 3 года назад

    Delete can be rollback, How❓

  • @ayushiojha6376
    @ayushiojha6376 3 года назад

    How to do this in phpmyadmin?

  • @ganeshgunjal4220
    @ganeshgunjal4220 4 года назад

    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?

    • @informativediscovery5091
      @informativediscovery5091 4 года назад

      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.........

    • @informativediscovery5091
      @informativediscovery5091 4 года назад

      agr waha pr bh samjh na aye tw fb pr contact karlo waha samjha dunga facebook.com/profile.php?id=100053722793422

    • @harmanpreetkaur8926
      @harmanpreetkaur8926 3 года назад

      same issue i m facing , if u have any solution , pls tell me

  • @AshokKumar-ii4qr
    @AshokKumar-ii4qr Год назад

    Mera me rollback nhi ho rha h

  • @manav9107
    @manav9107 2 месяца назад

    Mera Rollback ni hua...

  • @ShaikSohail-l7z
    @ShaikSohail-l7z Год назад

    Here we got know salman khan salary.

  • @bhaveshtupe4163
    @bhaveshtupe4163 Год назад

    update command not working ....

    • @YahooBaba
      @YahooBaba  Год назад

      paste your command here. I will check it.

  • @burhanali1474
    @burhanali1474 3 месяца назад

    mayra rollback nhi ho raha

  • @Suryadey9784
    @Suryadey9784 10 месяцев назад

    Wecube yeha se video copy kiya

  • @nikhilyadav8762
    @nikhilyadav8762 3 года назад

    Wo sab to thik hai lekin jiss table me Example dete ho usi me task kyun nai perform karte jayda achhe se samajh aayega

  • @anindian4601
    @anindian4601 3 года назад +1

    ROLL BACK = UNDO

  • @ANKITPRAJAPATI-iq7mb
    @ANKITPRAJAPATI-iq7mb 4 года назад

    drive.google.com/file/d/100bWQH7OXN916qSTnYLPClnr3ui7qk1h/view?usp=drivesdk
    Sir mera roll kam nhi kr rha ..

  • @bhushansapkal8310
    @bhushansapkal8310 2 года назад

    Ye wala bilkul nai samjha

  • @asadshaikh4643
    @asadshaikh4643 2 года назад +2

    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

  • @manishaverma81
    @manishaverma81 2 года назад

    Thank you sir . very well explained👌👌

  • @saikrishna6344
    @saikrishna6344 4 года назад

    Thank you sir👌👌clear

  • @mayanksen7476
    @mayanksen7476 3 года назад

    thankyou sir..

  • @sadiaanjum7737
    @sadiaanjum7737 Год назад

    Well explained