Is MySQL stored procedure transactional by default?

Question

I have a MySQL stored procedure which reads and updates multiple tables, so I want it to be a transaction. Is it already transactional by default? Or do i need to do something?

MySQL 5.0+

Ted Hopp · Accepted Answer · 2011-05-30 03:23:50Z

4

I don't believe so. According to the manual section on BEGIN...END statements:

Within all stored programs (stored procedures and functions, triggers, and events), the parser treats BEGIN [WORK] as the beginning of a BEGIN ... END block. Begin a transaction in this context with START TRANSACTION instead.

Also see the manual on START TRANSACTION, COMMIT, and ROLLBACK Syntax.

answered May 30, 2011 at 3:23

Ted Hopp

235k48 gold badges412 silver badges533 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is MySQL stored procedure transactional by default?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related