Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TITOLO(isin varchar(12), maxAss int, minAss int, primary key(isin))
- QUOTAZIONE(id int, min int, max int, date date, isin varchar(12), primary key(id), foreign key(isin) references TITOLO(isin))
- DELIMITER $$
- CREATE TRIGGER AggiornaTitolo
- AFTER INSERT ON quotazione
- FOR EACH ROW BEGIN
- DECLARE massimo int;
- DECLARE minimo int;
- SELECT maxAss, minAss INTO massimo, minimo FROM titolo WHERE titolo.isin = NEW.isin;
- IF massimo > maxAss THEN
- UPDATE titolo
- SET maxAss = massimo;
- IF minimo < minAss THEN
- UPDATE titolo
- SET minAss = minimo; END IF;
- END;
- $$ DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement