List:General Discussion« Previous MessageNext Message »
From:Scott Hamm Date:October 26 2005 2:53pm
Subject:DELETE Trigger
View as plain text  
How do I create a trigger in MySQL similiar to the trigger created for mssql:

CREATE TRIGGER DEL_DE ON KRONOS
AFTER DELETE
AS
	DELETE FROM
		DE_Metrics
	WHERE
		KID=(
			SELECT
				ID
			FROM
				DELETED
		);

I already read online mysql TRIGGER, CREATE TRIGGER and USING TRIGGER
to no avail.
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
Thread
DELETE TriggerScott Hamm26 Oct
  • Re: DELETE TriggerMartijn Tonies26 Oct