NAME

COMMIT - 提交當前事務

SYNOPSIS

COMMIT [ WORK | TRANSACTION ]

DESCRIPTION 描述

COMMIT 提交當前事務。 所有事務的更改都將為其他事務可見，而且保證當崩潰發(fā)生時的可持續(xù)性。  

PARAMETERS 參數(shù)

WORK

TRANSACTION

 可選關鍵字。沒有作用。

NOTES 注意

 使用 ROLLBACK [rollback(7)] 語句退出一次事務。

 在一個事務內部發(fā)出 COMMIT 不會有問題，但是他將產(chǎn)生一個警告信息。  

EXAMPLES 例子

 要讓所有變更永久化：

COMMIT;

COMPATIBILITY 兼容性

SQL92 只聲明了兩種形式 COMMIT 和 COMMIT WORK。否則完全兼容。  

SEE ALSO 參見

BEGIN [begin(7)], ROLLBACK [rollback(l)]

#p#

NAME

COMMIT - commit the current transaction

SYNOPSIS

COMMIT [ WORK | TRANSACTION ]

DESCRIPTION

COMMIT commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.  

PARAMETERS

WORK

TRANSACTION

Optional key words. They have no effect.

NOTES

Use ROLLBACK [rollback(7)] to abort a transaction.

Issuing COMMIT when not inside a transaction does no harm, but it will provoke a warning message.  

EXAMPLES

To commit the current transaction and make all changes permanent:

COMMIT;

COMPATIBILITY

The SQL standard only specifies the two forms COMMIT and COMMIT WORK. Otherwise, this command is fully conforming.  

SEE ALSO

BEGIN [begin(7)], ROLLBACK [rollback(l)]