MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?

by

You can actually up the rows in the same table as the trigger. The thread you linked to even has the solution.

For example:

TestTable ( id / lastmodified / random )

create trigger insert_lastmod
before insert on TestTable
for each row
set NEW.lastmodified = NOW();

insert into TestTable ( `random` ) values ( 'Random' );

select * from TestTable;
+----+---------------------+---------------------+
| id | lastmodified        | random              |
+----+---------------------+---------------------+
|  1 | 2010-12-22 14:15:23 | Random              |
+----+---------------------+---------------------+

More Related Contents:

  1. MySQL stored procedures use them or not to use them
  2. Throw an error preventing a table update in a MySQL trigger
  3. What does character set and collation mean exactly?
  4. MySQL Trigger after update only if row has changed
  5. Implementing Comments and Likes in database
  6. Auto Generate Database Diagram MySQL [closed]
  7. In SQL, is it OK for two tables to refer to each other?
  8. Modeling Product Variants
  9. How to design a multi tenant mysql database
  10. DOs and DONTs for Indexes [closed]
  11. How do you debug MySQL stored procedures?
  12. Difference between two table structure
  13. Proper database model for a user feedback system (an interesting case)
  14. How to schedule a stored procedure in MySQL
  15. Can I launch a trigger on select statement in mysql?
  16. Strings as Primary Keys in MYSQL Database [closed]
  17. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  18. Inventory management with stock options
  19. How to store multiple options in a single table?
  20. Is there a MySQL option/feature to track history of changes to records?
  21. Can I create view with parameter in MySQL?
  22. MySQL: multiple tables or one table with many columns? [closed]
  23. single fixed table with multiple columns vs flexible abstract tables
  24. MySQL trigger On Insert/Update events
  25. How do I get the ID of multiple inserted rows in MySQL?
  26. Case statement in MySQL
  27. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  28. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  29. How to Get True Size of MySQL Database?
  30. Should I always prefer MySQL InnoDB over MyISAM?

Leave a Comment