NAME

COMMIT - 提交當(dāng)前事務(wù)

SYNOPSIS

COMMIT [ WORK | TRANSACTION ]

DESCRIPTION 描述

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

PARAMETERS 參數(shù)

WORK

TRANSACTION

 可選關(guān)鍵字。沒(méi)有作用。

NOTES 注意

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

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

EXAMPLES 例子

 要讓所有變更永久化：

COMMIT;

COMPATIBILITY 兼容性

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

SEE ALSO 參見(jiàn)

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)]