How can I use transactions in my MySQL stored procedure?

by

Two syntax errors:

  • You need commas in between the conditions for your exit handler. Notice the syntax documentation shows commas.

  • You need to terminate the END of the exit handler with a semicolon. The DECLARE statement itself (including its BEGIN…END block) is a statement like any other, and need to have a terminator.

So you need this:

DECLARE EXIT HANDLER FOR SQLEXCEPTION, SQLWARNING
BEGIN
    ROLLBACK;
END;

More Related Contents:

  1. MySQL : transaction within a stored procedure
  2. MySQL AUTO_INCREMENT does not ROLLBACK
  3. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  4. Can I create view with parameter in MySQL?
  5. Pass array to MySQL stored routine
  6. Connect By Prior Equivalent for MySQL
  7. MySQL stored procedure vs function, which would I use when?
  8. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  9. mysql transaction – roll back on any exception
  10. MySQL create stored procedure syntax with delimiter
  11. mysql dynamic query in stored procedure
  12. Writing optional parameters within stored procedures in MySQL? [duplicate]
  13. Dynamic table names in stored procedure function
  14. List of Stored Procedures/Functions Mysql Command Line
  15. passing LIMIT as parameters to MySQL sproc
  16. mysql stored procedure that calls itself recursively
  17. How to enable INNODB in mysql
  18. How to display open transactions in MySQL
  19. MySQL Stored Procedure Error Handling
  20. MySQL Stored Procedures not working with SELECT (basic question)
  21. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  22. How to schedule a stored procedure in MySQL
  23. MySQL : When stored procedure parameter name is the same as table column name
  24. How to use Table output from stored MYSQL Procedure
  25. How do I write an SP in phpMyAdmin (MySQL)?
  26. Call a stored procedure for each row returned by a query in MySQL
  27. MySQL ‘select for update’ behaviour
  28. Automatic Rollback if COMMIT TRANSACTION is not reached
  29. Mysql stored procedure don’t take table name as parameter
  30. How to pass a variable to a IN clause?

Leave a Comment