1. [MySQL] START TRANSACTION, COMMIT, and ROLLBACK Statements

    참고

    MySQL Documentation 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements

    설명

    • 트랜잭션을 컨트롤하는데 사용

    syntax

    START TRANSACTION
        [transaction_characteristic [, transaction_characteristic] ...]
    
    transaction_characteristic: {
        WITH CONSISTENT SNAPSHOT
      | READ WRITE
      | READ ONLY
    }
    
    BEGIN [WORK]
    COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE …
    read more
  2. [MySQL] Statement Labels

    참고

    MySQL Documentation 13.6.2 Statement Labels

    설명

    • BEGIN ... END 블록의 고유한 이름으로 사용

    syntax

    [begin_label:] BEGIN
        [statement_list]
    END [end_label]
    
    [begin_label:] LOOP
        statement_list
    END LOOP [end_label]
    
    [begin_label:] REPEAT
        statement_list
    UNTIL search_condition
    END REPEAT [end_label]
    
    [begin_label:] WHILE search_condition DO
        statement_list …
    read more

links

social