my mysql after insert trigger isn't working? why?
i've combined trigger resembles following:
delimiter //
create trigger update_total_seconds_on_phone after insert
on cdr
for any quarrel
begin
if new.billsec > 0 new.userfield <> zero then
update foo
set total_seconds = total_seconds + new.billsec
where phone_id = new.userfield;
end if;
end;//
it seems by okay. however doesn't seem invoking i need to. here's an example:
mysql> name total_seconds foo where phone_id = 1;
+---------------+
| total_seconds |
+---------------+
| 0 |
+---------------+
1 quarrel set (0.00 sec)
mysql> insert cdr (billsec, userfield) values(60, 1);
query ok, 1 quarrel affected, 12 warnings (0.00 sec)
mysql> name total_seconds foo where phone_id = 1;
+---------------+
| total_seconds |
+---------------+
| 0 |
+---------------+
edit: warnings sole box impact trigger. it's mostly additional columns have default values cdr list means warnings. effect simplicity, i kept insert matter brief.
Comments
Post a Comment