MySQL Transactional and Locking Statements -MySQL Tutorials

MySQL5.0 supports local transactions by statements like START TRANSACTION, SET AUTOCOMMIT, COMMIT and ROLLBACK. Transaction means a group of SQL Statements, which executes as a unit. And MySQL either executes all the statement successfully or it doesn’t execute anyone. This can be achieved by the commit and rollback. When all the statements executes successfully then [...]