TCL also known as Transaction Control Language.It is used to manage different transactions occurring within a database.Various statements included under this category are:
1) COMMIT
2) ROLLBACK
COMMIT:
This is used to commit or saving the changes permanently you have made.Syntax:
COMMIT;
ROLLBACK:
It is used to discard the changes you have made.Syntax:
ROLLBACK;
IMPORTANT POINTS:
1) In case of Mysql,always use START TRANSACTION at the beginning.
2) When you use commit/rollback.It will commit/rollback the changes you have made after writing START TRANSACTION.
Do you like this article? Share It!
0 comments to "TRANSACTION CONTROL LANGUAGE"
Post a Comment