MySQL : transaction within a stored procedure

by

Take a look at http://dev.mysql.com/doc/refman/5.0/en/declare-handler.html

Basically you declare error handler which will call rollback

START TRANSACTION;

DECLARE EXIT HANDLER FOR SQLEXCEPTION 
    BEGIN
        ROLLBACK;
        EXIT PROCEDURE;
    END;
COMMIT;

More Related Contents:

  1. Connect By Prior Equivalent for MySQL
  2. MySQL create stored procedure syntax with delimiter
  3. mysql dynamic query in stored procedure
  4. When to use SELECT … FOR UPDATE?
  5. How to enable INNODB in mysql
  6. How can I use transactions in my MySQL stored procedure?
  7. MySQL Stored Procedures not working with SELECT (basic question)
  8. Split a string and loop through values in MySQL stored procedure
  9. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  10. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  11. What is dynamic SQL?
  12. Recreating a query using INNER JOIN? [duplicate]
  13. How to perform grouped ranking in MySQL
  14. MySQL Trigger after update only if row has changed
  15. MySQL “WITH” clause
  16. Ordering by specific field value first
  17. MySQL “Group By” and “Order By”
  18. MySQL Query to select data from last week?
  19. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  20. How do I use properly CASE..WHEN in MySQL
  21. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  22. SQL unique varchar case sensitivity question
  23. Is it possible to have a default parameter for a mysql stored procedure?
  24. How do I count columns of a table
  25. Difference between two table structure
  26. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  27. Why MySQL is giving error “Not allowed to return a result set from a function”?
  28. When to use a left outer join?
  29. MySQL 5.6 – DENSE_RANK like functionality without Order By
  30. Update multiple rows with multiple ‘where’ clauses for each individual row

Leave a Comment