• BEGIN
• COMMIT or ROLLBACK
• AUTOCOMMIT is default behavior, requiring BEGIN
• SET AUTOCOMMIT=0; # will require an explicit COMMIT transaction to register changes
• LOCK IN SHARE MODE: this prevents rows from being updated while you are working on it. If there is uncommitted data, then your process will wait until it has been committed before continuing.
• Specify your tables as InnoDB to ensure transactions work as you expect.
NEXT
INDEX
Master Index