Shulou(Shulou.com)06/03 Report--

This article will explain in detail what is the order for the successful submission of transactions. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

The command for successful transaction commit is "commit", and the COMMIT command is used to save the changes made by the transaction to the database. It saves all transactions after the last COMMIT or ROLLBACK command to the database, and the syntax is "commit [work];".

The command used for transaction commit is commit

The COMMIT command is used to save the changes made by the transaction to the database, and it saves all transactions since the last COMMIT or ROLLBACK command to the database.

Grammar

Commit [work]

Input

WORK, TRANSACTION

Optional keyword, the only function is to make the command more user-friendly.

Output

COMMIT

This information was returned after a successful submission.

NOTICE: COMMIT: no transaction in progress

If there is no transaction in the process, this information is returned.

Be careful

The keywords WORK and TRANSACTION can be ignored.

Use the ROLLBACK statement to exit a transaction.

Commit the current transaction using COMMIT to perpetuate changes executed in the transaction, make all transaction changes visible to other transactions, and ensure sustainability in the event of a crash

View any changes made during the transaction through the modified table, but other users cannot see the changes

You can roll back any changes made during ROLLBACK statements and transactions

You can use this statement to manually submit questions on distributed transactions

You can use this statement to terminate a read-only transaction of a SET TRANSACTION statement

The command on what is a successful transaction commit is shared here. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.