MySQL – Trigger for updating same table after insert

by

It seems that you can’t do all this in a trigger. According to the documentation:

Within a stored function or trigger, it is not permitted to modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger.

According to this answer, it seems that you should:

create a stored procedure, that inserts into/Updates the target table, then updates the other row(s), all in a transaction.

With a stored proc you’ll manually commit the changes (insert and update). I haven’t done this in MySQL, but this post looks like a good example.

More Related Contents:

  1. Using LIMIT within GROUP BY to get N results per group?
  2. How can I output MySQL query results in CSV format?
  3. How do I add indexes to MySQL tables?
  4. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  5. MySQL error: key specification without a key length
  6. Select row with most recent date per user
  7. Suppress warning messages using mysql from within Terminal, but password written in bash script
  8. How can I view live MySQL queries?
  9. Is it possible to execute a string in MySQL?
  10. Cannot connect to Database server (mysql workbench)
  11. Convert partially non-numeric text into number in MySQL query
  12. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  13. MYSQL ORDER BY CASE Issue
  14. Can’t use a MySQL connection for entity framework 6
  15. MySQL difference between two rows of a SELECT Statement
  16. MySQL Select last 7 days
  17. connecting to mysql server on another PC in LAN
  18. MySQL view performance
  19. Does MySQL Regexp support Unicode matching
  20. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  21. How to retrieve JSON data from MySQL?
  22. Is incrementing a field in MySQL atomic?
  23. Delete from one table with join
  24. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  25. When to use a left outer join?
  26. MySQL: Compare BETWEEN time
  27. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  28. MySQL Recursive get all child from parent
  29. is it possible to call a sql script from a stored procedure in another sql script?
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment