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

preview_player
Показать описание
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:

👍 LIKE ✍ COMMENT ✉ SHARE ❤ SUBSCRIBE
Рекомендации по теме
Комментарии
Автор

Bariya sir ji apka paraya hua smjh me bhi aya or program run bhi hua ji thanku sir ji

lalitupadhyay
Автор

Thank you, i don't in clg but when i see your video i fully understand because you teach practically on Oracle and it is good teaching method.

hitengamer
Автор

You are uploading this video...on my request 🙏❤ Thank you so much sir

kunaljadhav
Автор

best video on TCL Query easy to understand thanks you..

akashtawar
Автор

I was so confused about this topic, thankyou so much sir for making it crystal clear:)

jannatbhengray
Автор

Excellent video!! clear explanation! keep it up!

a.v
Автор

thank you for saving me (i have my practical exam tomorrow)

EdJoseph-zb
Автор

Sir jo ap display ko zoom or zoomback krte ho acc. To liye konsi key use krte ho

VaibhavKumar-dduv
Автор

Please also make a video on Grant and Revoke Command ❤🙏

Sunnyyadav-jppc
Автор

can you please create a video on 1) clauses - where, from, group by, having, order by
2) set operators - union, union all minus, intersect
3) numeric functions and character/string functions

Adarshplays
Автор

Sir primary key aur foreign key in my sql bnaye video 2 din tk plz😢

LEGENDSTATUS-ok
Автор

Group by function ke liye bhi video bna do sir

MohitBhatt-qmno
Автор

Sir you can use your up and down arrow to get previous query you will not have to write same queries again and again
As I saw to write select * from student1 you have to type every my but by clicking up and down arrow you can use your previous commands or queried

krishsscodes
Автор

Sir please start teaching chapter of cbse class 12 IT
It will be great ❤

Snigdha
Автор

Hi sir ji class 12 computer science good ha ji😊❤❤ ❤❤❤❤❤❤❤likes kra

gagan_deep_
Автор

Sir isse pehle video me single quote ' ' ' ka use kiya tha isme "" double quote kyu.. please help

Vsohkakd
Автор

sir make a video on windows functions and common table expression

nitishbhuyan
Автор

it's really helpful to me brother tq soo much

vijayalakshmi
Автор

Thanks mujhe padhana hai but koi contact exam ke lye bhut topic hai MySQL ke 😭😭😭😭😭😭😭😭

Sayyednurinzehra
Автор

Sir user creation granting revoke permission on database object 2:43 please ase make this voide sir I need to

sakshikatkar