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.