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?

瀏覽:1430
日期:2025-10-04
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 ......看更多