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

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?