What is the command for successful transaction submission?

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

The command used to commit the transaction is commit

The COMMIT command is used to commit the transaction The modifications are saved to the database. It saves all transactions after the last COMMIT or ROLLBACK command to the database.

Syntax

commit [work];

Input

WORK, TRANSACTION

Optional keywords whose only function is to make the command more user-friendly.

Output

COMMIT

This information is returned if the submission is successful.

NOTICE: COMMIT: no transaction in progress

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

Note

The keywords WORK and TRANSACTION can be ignored.

Use the ROLLBACK statement to exit a transaction.

Use COMMIT to commit the current transaction, making the changes performed in the transaction permanent, all transaction changes will be visible to other transactions, and ensuring sustainability when a crash occurs;

Passed Modified tables, view any changes made during the transaction, but other users cannot see the changes;

You can roll back the ROLLBACK statement and any changes made during the transaction;

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

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

The above is the detailed content of What is the command for successful transaction submission?. For more information, please follow other related articles on the PHP Chinese website!