
Trigger en PHPMyadmin
Publicado por carlos (4 intervenciones) el 22/05/2014 05:31:36
Hola, tengo un trigger que debo hacer en PHPMyadmin pero no se como ejecutarlo, se compone de una funcion y luego el trigger:
--------------------funcion----------------------
CREATE OR REPLACE FUNCTION CONTROL() RETURNS TRIGGER AS $$
DECLARE
NUM_CUADROS INT;
IF(TG_OP='INSERT' THEN
SELECT COUNT(*) INTO NUM_CUADROS FROM restauracion
WHERE id_Restaurador= NEW.id_Restaurador;
IF NUM_CUADROS >=3 THEN
RAISE EXCEPTION 'LIMITE DE RESTAURACIONES ALCANZADAS';
ELSE
RETURN NEW;
END IF;
ELSE
RETURN NEW;
END IF;
END;
$$
---------------------------------------trigger-----------------------
CREATE TRIGGER TRG_NUM_CUADROS
BEFORE INSERT ON RESTAURACION
FOR EACH ROW EXECUTE PROCEDURE CONTROL();
--------------------------------------------------ERROR QUE ME SALE AL EJECUTARLO -----------------------------------------------------
Error
consulta SQL:
CREATE OR REPLACE FUNCTION CONTROL(
)
RETURNS TRIGGER AS $$
DECLARE NUM_CUADROS INT;
MySQL ha dicho: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FUNCTION CONTROL() RETURNS TRIGGER AS $$
DECLARE
NUM_CUADROS INT' at line 1
----------------------------------------------------------------------------------------------------------------------
Agradezco cualquier ayuda
--------------------funcion----------------------
CREATE OR REPLACE FUNCTION CONTROL() RETURNS TRIGGER AS $$
DECLARE
NUM_CUADROS INT;
IF(TG_OP='INSERT' THEN
SELECT COUNT(*) INTO NUM_CUADROS FROM restauracion
WHERE id_Restaurador= NEW.id_Restaurador;
IF NUM_CUADROS >=3 THEN
RAISE EXCEPTION 'LIMITE DE RESTAURACIONES ALCANZADAS';
ELSE
RETURN NEW;
END IF;
ELSE
RETURN NEW;
END IF;
END;
$$
---------------------------------------trigger-----------------------
CREATE TRIGGER TRG_NUM_CUADROS
BEFORE INSERT ON RESTAURACION
FOR EACH ROW EXECUTE PROCEDURE CONTROL();
--------------------------------------------------ERROR QUE ME SALE AL EJECUTARLO -----------------------------------------------------
Error
consulta SQL:
CREATE OR REPLACE FUNCTION CONTROL(
)
RETURNS TRIGGER AS $$
DECLARE NUM_CUADROS INT;
MySQL ha dicho: Documentación
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FUNCTION CONTROL() RETURNS TRIGGER AS $$
DECLARE
NUM_CUADROS INT' at line 1
----------------------------------------------------------------------------------------------------------------------
Agradezco cualquier ayuda
Valora esta pregunta


0