Complete Transaction SQL/MYSQL Query in One Video | Commit, Rollback, Savepoint 2023

Опубликовано: 20 Октябрь 2024
на канале: Kailash Joshi Tutorials
35,611
748

In this video, I explain to you the Transaction Command
Commit
Rollback
Savepoint
Commit: COMMIT in SQL is a transaction control language used to permanently save the changes done in the transaction in tables/databases. The database cannot regain its previous state after it executes the commit.
Rollback: ROLLBACK in SQL is a transactional control language used to undo transactions that have not been saved in the database. The command is only been used to undo changes since the last COMMIT.
Savepoint: A SAVEPOINT is a point in a transaction in which you can roll the transaction back to a certain point without rolling back the entire transaction.
Mysql/SQL Part01:
Python important interview question:    • Python Interview Important Questions ...  

Python download and install:    • How to Install Python | Run first pro...  

Python Path set Link -   • how to set path of python in windows ...  

Java important interview question:    • Java Interview Questions(2022) and An...  

Database important question:    • DBMS/RDBMS Interview Question Answer ...  

Python Playlist Link -    • Python Programming for beginners  

Channel Subscription:    / @kailashjoshitutorials  

👍 LIKE ✍ COMMENT ✉ SHARE ❤ SUBSCRIBE