film Harry Potter à lécole des sorciers | regarder film Yéti Compagnie (2018) | iMindMap 11
 Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Start Transaction, Commit, and Rollback Mysql Statement

Example of Start Transaction, Commit, and Rollback Mysql Statement:

START TRANSACTION;
SELECT
@A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET [email protected] WHERE type=1;
COMMIT;

START TRANSACTION WITH CONSISTENT SNAPSHOT;

Example of Mysql Start Transaction, Commit, and Rollback

START TRANSACTION [WITH CONSISTENT SNAPSHOT] | BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET
autocommit = {0 | 1}