Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trigger code doesn't seem to attach to table (MySQL5)

Status
Not open for further replies.

mbabcock

Programmer
Jul 25, 2006
32
US
Here's my trigger code:
DELIMITER $$

DROP TRIGGER /*!50032 IF EXISTS */ `piecerate`.`spUpdate_Queue`$$

create trigger `piecerate`.`spUpdate_Queue` AFTER UPDATE on
`piecerate`.`queue`
for each row BEGIN
call spUpdateQueueCounts(new.iorderid);
insert into crap (iid,iorderid) values (new.iid,new.iorderid);
END;
$$

DELIMITER ;


To test, I do a simple update sql:

UPDATE queue SET ipriority = ipriority

But when I look in the CRAP table, there's still no records. I don't
get it...what's missing?

I'd also like to know if there's a way to step through and debug code like I can do in Visual FoxPro.

tia!
--Michael
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top