這條命令開始一個新的事務。如果聲明了隔離級別或者讀寫模式, 那麼新事務就使用這個特性,如同執行了 SET TRANSACTION [set_transaction(7)] 一樣。在其它方面,這條命令的行為和 BEGIN [begin(7)] 命令一樣。
作者:何偉平來源:CMPP.net|2011-08-24 18:19START TRANSACTION - 開始一個事務塊
SYNOPSISSTART TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]
DESCRIPTION 描述
這條命令開始一個新的事務。如果聲明了隔離級別或者讀寫模式, 那麼新事務就使用這個特性,如同執行了 SET TRANSACTION [set_transaction(7)] 一樣。在其它方面,這條命令的行為和 BEGIN [begin(7)] 命令一樣。
參閱 SET TRANSACTION [set_transaction(7)] 獲取有關參數含義的信息。
這條命令兼容 SQL 標準;但是又見 SET TRANSACTION [set_transaction(7)] 的兼容性小節。
BEGIN [begin(7)], COMMIT [commit(l)], ROLLBACK [rollback(l)], SET TRANSACTION [set_transaction(l)]
NAMESTART TRANSACTION - start a transaction block
SYNOPSISSTART TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]
DESCRIPTIONThis command begins a new transaction. If the isolation level or read/write mode is specified, the new transaction has those characteristics, as if SET TRANSACTION [set_transaction(7)] was executed. In all other respects, the behavior of this command is identical to the BEGIN [begin(7)] command.
PARAMETERSSee under SET TRANSACTION [set_transaction(7)] about the meaning of the parameters.
COMPATIBILITYThis command conforms to the SQL standard; but see also the compatibility section of SET TRANSACTION [set_transaction(7)].
SEE ALSOBEGIN [begin(7)], COMMIT [commit(l)], ROLLBACK [rollback(l)], SET TRANSACTION [set_transaction(l)]
【責任編輯:
韓亞珊TEL:(010)68476606】