As far as I know, you can´t change data on the same table in triggers.
"Kevin Labecot" escreveu na mensagem
news:4d2ce38b-d169-478b-aebf-c19f20dce...@labecot.fr...
Hi,
Is there a way to update the same table on a delete trigger ?
I need to call an UPDATE statement when a del
Hi,Is there a way to update the same table on a delete trigger ?I need to call an UPDATE statement when a delete occurs.Best regards
-- Kevin Labecot, Innovanticwww.innovantic.frTél. : 05.56.45.60.54
Hello Scott,
> 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 TRIG
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