Jump to content


Photo

MySQL Triggers


  • Please log in to reply
No replies to this topic

#1 shivi

shivi
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 02 March 2003 - 03:40 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users