Hola
Gonzalo, ahora me dice
#1227 - Access denied; you need the SUPER privilege for this operation
Código PHP:
DELIMITER $$
CREATE TRIGGER `inser` BEFORE INSERT on `cpupreorden`
FOR EACH ROW
BEGIN
DECLARE entries INT;
SELECT COUNT(*) INTO entries FROM cpupreorden
WHERE ordencompra = '18066100554753d281877d15.06587328'
GROUP BY ordencompra;
IF (entries = 0) THEN
INSERT INTO cpupreorden (id, user, modelo, componente, ide, precio, ordencompra, fecha)
VALUES ('', 'Augustino', '1', 'Gabinete', '1', '55', '18066100554753d281877d15.06587328', now());
END IF;
END$$
DELIMITER ;