26 Matching Annotations
  1. Sep 2023
  2. Jul 2023
  3. May 2023
  4. Apr 2023
  5. Mar 2023
    1. autocommit is a session variable and must be set for each session. To disable autocommit mode for each new connection, see the description of the autocommit system variable

      a

    2. Specifying READ ONLY ensures these optimizations are applied in cases where the read-only status cannot be determined automatically. See Section 8.5.3, “Optimizing InnoDB Read-Only Transactions”

      a

    3. To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION

      sql START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT;

    4. These statements provide control over use of transactions:

      ```sql START TRANSACTION [transaction_characteristic [, transaction_characteristic] ...]

      transaction_characteristic: { WITH CONSISTENT SNAPSHOT | READ WRITE | READ ONLY }

      BEGIN [WORK] COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE] ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE] SET autocommit = {0 | 1} ```

  6. Feb 2023
  7. Jan 2023