MySQL Forums :: Triggers :: Help with trigger

Advanced Search

Re: Help with trigger
Posted by: Ronan Cashell ()
Date: April 23, 2012 08:02AM

Have a look at this will explain how triggers work with examples:

Your particular trigger would be something like:

CREATE TRIGGER appointment01
AFTER UPDATE ON appointments
UPDATE patients SET date_of_last_appointment = new.date_of_appointment WHERE patient_id = new.patient_id;

Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions

Options: ReplyQuote

Subject Views Written By Posted
Help with trigger 2050 Bryony Thompson 04/23/2012 04:35AM
Re: Help with trigger 962 laptop alias 04/23/2012 08:00AM
Re: Help with trigger 1060 Ronan Cashell 04/23/2012 08:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.