mysql trigger stored trigger is already used by statement which invoked stored trigger

by

MySQL triggers can’t manipulate the table they are assigned to. All other major DBMS support this feature so hopefully MySQL will add this support soon.

http://forums.mysql.com/read.php?99,122354,240978#msg-240978

More Related Contents:

  1. MySQL Trigger after update only if row has changed
  2. Updating table in trigger after update on the same table
  3. SQL select only rows with max value on a column [duplicate]
  4. How to create a MySQL hierarchical recursive query?
  5. SELECTING with multiple WHERE conditions on same column
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. How to find gaps in sequential numbering in mysql?
  8. MySQL: Invalid use of group function
  9. Combining UNION and LIMIT operations in MySQL query
  10. MySQL comparison with null value
  11. Matching all values in IN clause
  12. INTERSECT in MySQL
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. How can I set a maximum number of rows in MySQL table?
  15. What does SQL clause “GROUP BY 1” mean?
  16. Sorting by date & time in descending order?
  17. Case statement in MySQL
  18. MySQL: Inner join vs Where [duplicate]
  19. Syntax error when using except in a query
  20. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  21. Selecting from two tables with inner join and limit [duplicate]
  22. Why the order of evaluation for expressions involving user variables is undefined?
  23. sql like operator on integer
  24. How to select data where a field has a min value in MySQL?
  25. MySQL – SELECT * INTO OUTFILE LOCAL ?
  26. How to SELECT by MAX(date)?
  27. The best way to remove value from SET field?
  28. get a recursive parent list
  29. Deleting a row based on the max value
  30. MySQL Multiple Joins in one query?

Leave a Comment