MySQL Consulting and NoSQL Consulting: MySQL DBA: Can MySQL triggers update another table?

MySQL Consulting and NoSQL Consulting: MySQL DBA: Can MySQL triggers update another table?

瀏覽:932
日期:2026-04-20
After playing earlier with triggers, I wanted to see whether one can update another table using MySQL triggers. I tried something like CREATE TRIGGER mytrigger BEFORE INSERT ON odp.points FOR EACH ROW SET total_points.points = total_points.points ......看更多