MYSQL Support transaction code?

In the default mode, MySQL is autocommit mode, and all database update operations are committed immediately. So, by default, MySQL does not support transactions.

But if your MySQL table type is innodb tables or BDB tables, you can use the transaction. The set autocommit=0 allows MySQL to run in non-autocommit mode.

In non-autocommit mode, you must use commit to commit your changes, or rollback to roll back your changes.

For example:

START TRANSACTION;

SELECT @a:=sum (Salary) from table where type=1;

UPDATE table2 Set [email protected] where type=1;

COMMIT;