BEGIN
目录
BEGIN
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·
NAME
BEGIN - å¼å§ä¸ä¸ªäºå¡å
SYNOPSIS
BEGIN [ WORK | TRANSACTION ]
DESCRIPTION æè¿°
BEGIN åå§åä¸ä¸ªäºå¡åï¼ ä¹å°±æ¯è¯´ææ BEGIN å½ä»¤åçç¨æ·è¯- å¥é½å°å¨ä¸ä¸ªäºå¡éé¢æ§è¡ç´å°ç»åºä¸ä¸ªæç¡®ç COMMIT [commit(7)] æè ROLLBACK [rollback(l)] ã 缺çæ¶ï¼ï¼æ²¡æ BEGINï¼ï¼PostgreSQL 以 "autocommit" 模å¼æ§è¡äºå¡ï¼ä¹å°±æ¯è¯´ï¼æ¯ä¸ªè¯å¥å¨å¶èªèº«çäºå¡ä¸- æ§è¡ï¼ 并ä¸å¨è¯å¥ç»æçæ¶åéå«å°æ§è¡ä¸ä¸ªæ交ï¼å¦ææ§è¡æåï¼å¦åæ§è¡åæ»ï¼ã
å¨äºå¡åéæ§è¡çè¯å¥å¾ææ¾å°å¿«å¾å¤ï¼ å 为äºå¡å¼å§/æ交ï¼start/commitï¼éè¦å¤§éçCPUåç£çæ´»å¨ã å¨ä¸ä¸ª äºå¡åé¨æ§è¡å¤æ¡è¯å¥å¯¹äºä¿®æ¹è¥å¹²ä¸ªç¸å³ç表çæ¶åä¹æ¯å¾æç¨çï¼ å¨ææç¸å³çæ´æ°å®æä¹åï¼å¶å®ä¼è¯çä¸å°ä¸é´çç¶æã
PARAMETERS åæ°
|
WORK |
TRANSACTION
å¯éå³é®åã没ä»ä¹ä½ç¨ã
NOTES 注æ
START TRANSACTION [start_transaction(7)] æçå BEGIN ä¸æ ·çåè½ã
ä½¿ç¨ COMMIT [commit(7)] æ ROLLBACK [rollback(7)] ç»æä¸ä¸ªäºå¡ã
å¨ä¸ä¸ªç°æäºå¡ååé¨ååºä¸ä¸ª BEGIN å°äº§çä¸ä¸ªè¦åä¿¡æ¯ã äºå¡çç¶æå°ä¸ä¼è¢«å½±åã
EXAMPLES ä¾å
å¼å§ä¸ä¸ªç¨æ·äºå¡ï¼
BEGIN;
COMPATIBILITY å¼å®¹æ§
BEGIN æ¯ PostgreSQL è¯è¨çæ©å±ã å¨ SQL æ åä¸æ²¡ææç¡®ç BEGIN çå®ä¹ï¼äºå¡åå§åæ»æ¯éå«çèä¸ä½¿ç¨ä¸ä¸ª COMMIT æè ROLLBACK è¯å¥ç»æ¢ã
许å¤å³ç³»åæ°æ®åºä¸ºäºæ¹ä¾¿æä¾ä¸ä¸ªèªå¨æ交ï¼autocommitï¼ç¹æ§ã
顺便说ä¸å¥ï¼BEGIN å³é®åå¨åµå¥ SQL éç¨äºä¸åçç®çã æä»¬å»ºè®®ä½ å¨ç§»æ¤æ°æ®åºåºç¨æ¶ä»ç»æ£æ¥äºå¡çè¯ä¹ã
SEE ALSO åè§
COMMIT [commit(7)], ROLLBACK [rollback(l)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh