Updating table in trigger after update on the same table

by

If you change your trigger to BEFORE instead of AFTER you could do it like this:

CREATE TRIGGER upd_total_votes BEFORE UPDATE ON products_score 
FOR EACH ROW 
BEGIN
    SET new.votes_total = new.votes_1 + new.votes_2 + new.votes_3 + new.votes_4 + new.votes_5 
END
;

More Related Contents:

  1. mysql trigger stored trigger is already used by statement which invoked stored trigger
  2. SQL Query needed for fetch value from Two identical table but not fully identical table
  3. SQL select only rows with max value on a column [duplicate]
  4. How to create a MySQL hierarchical recursive query?
  5. Error related to only_full_group_by when executing a query in MySql
  6. How to reset AUTO_INCREMENT in MySQL
  7. How to declare a variable in MySQL?
  8. MySQL Query GROUP BY day / month / year
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. MySQL Cannot Add Foreign Key Constraint
  11. Grouping into interval of 5 minutes within a time range
  12. SQL counting all rows instead of counting individual rows
  13. Convert timestamp to date in MySQL query
  14. Update a column value, replacing part of a string
  15. MySQL comparison with null value
  16. MySQL Like multiple values
  17. In MySQL, should I quote numbers or not?
  18. Matching all values in IN clause
  19. MySQL add days to a date
  20. INTERSECT in MySQL
  21. mysql dynamic query in stored procedure
  22. Check for x consecutive days – given timestamps in database
  23. How to alter a column and change the default value?
  24. How to select one row randomly taking into account a weight?
  25. Remove special characters from a database field
  26. MySQL – Replace Character in Columns
  27. Sort the rows according to the order specified in WHERE IN clause
  28. update a column by subtracting a value
  29. How do you force mysql LIKE to be case sensitive? [duplicate]
  30. In what order are MySQL JOINs evaluated?

Leave a Comment