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.


0 comments to "TRANSACTION CONTROL LANGUAGE"

Post a Comment

Powered by Blogger.