Jump to content

Archived

This topic is now archived and is closed to further replies.

shivi

MySQL Triggers

Recommended Posts

Hi all

 

I\'m not sure if MySQL supports triggers, or the syntax...

but here\'s what I\'m trying to do:

when I delect a record from a table, I want to create an entry into another table with information about the item deleted, pulled from 2 tables (including the one where the delete occured): BidInfo and ItemInfo.

 

So so far I have this:

[php:1:0a2b991aad]

CREATE TRIGGER trigger AFTER DELETE

ON BidInfo FOR EACH ROW

EXECUTE PROCEDURE ( INSERT INTO BuyInfo SET

ItemID = \'ItemID from BidInfo for deleted row\',

Seller = \'UserID from ItemInfo for ItemID\',

Buyer = \'CurrBidder from BidInfo\',

MaxBid = \'CurrBid from BidInfo for deleted row\');

[/php:1:0a2b991aad]

 

I really don\'t know how to fill in what\'s in the quotes...all these tables are linked by ItemID, the primary key in each.

 

Can anyone help??

Shivi.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.