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