emprunt.trg

来自「a small application in Mysql and Delphi」· TRG 代码 · 共 5 行

TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER  CTRL_nbremp_delet\nAFTER DELETE  ON emprunt \nFOR EACH  ROW\nUPDATE film \nSET nb_emprunts = (SELECT COUNT( * ) \n                                      FROM Emprunt\n                                     WHERE (film.code_film = emprunt.code_film)\n                                     GROUP BY F.code_film )' 'CREATE DEFINER=`root`@`localhost` TRIGGER  MAj_exemlaire\nAFTER INSERT ON emprunt\nFOR EACH  ROW\nBEGIN\nDELETE  FROM  emprunt\nWHERE   NEW.date_emprunt > date_emprunt\nAND  NEW.code_film=code_film\nAND NEW.code_exemplaire=code_exemplaire ;\nUPDATE film SET nb_emprunts = ( \nSELECT COUNT( * ) FROM Emprunt\nWHERE (film.code_film = emprunt.code_film)\nGROUP BY code_film \n) ;\nEnd'
sql_modes=1344274432 1344274432
definers='root@localhost' 'root@localhost'