Breaking News: Grepper is joining You.com. Read the official announcement!

CREATE TRIGGER trg_excluir_cliente BEFORE DELETE ON Clientes FOR EACH ROW BEGIN DECLARE pedidos_existentes INT; SELECT COUNT(*) INTO pedidos_existentes FROM Pedidos WHERE cliente_id = OLD.cliente_id; IF pedidos_existentes > 0 THEN SIGNAL SQLSTATE '45000'

Derick Willer answered on June 10, 2023 Popularity 1/10 Helpfulness 1/10

answer CREATE TRIGGER trg_excluir_cliente BEFORE DELETE ON Clientes FOR EACH ROW BEGIN DECLARE pedidos_existentes INT; SELECT COUNT(*) INTO pedidos_existentes FROM Pedidos WHERE cliente_id = OLD.cliente_id; IF pedidos_existentes > 0 THEN SIGNAL SQLSTATE '45000'

CREATE TRIGGER trg_excluir_cliente BEFORE DELETE ON Clientes FOR EACH ROW BEGIN DECLARE pedidos_existentes INT; SELECT COUNT(*) INTO pedidos_existentes FROM Pedidos WHERE cliente_id = OLD.cliente_id; IF pedidos_existentes > 0 THEN SIGNAL SQLSTATE '45000'

Comment

CREATE TRIGGER trg_excluir_cliente
BEFORE DELETE ON Clientes
FOR EACH ROW
BEGIN
    DECLARE pedidos_existentes INT;
    SELECT COUNT(*) INTO pedidos_existentes FROM Pedidos WHERE cliente_id = OLD.cliente_id;
    IF pedidos_existentes > 0 THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Não é possível excluir o cliente. Existem pedidos associados a ele.';
    END IF;
END;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: declare each row select sql where

Link to this answer
Share Copy Link

Contributed on Jun 10 2023

Derick Willer

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

CREATE TRIGGER trg_excluir_cliente BEFORE DELETE ON Clientes FOR EACH ROW BEGIN DECLARE pedidos_existentes INT; SELECT COUNT(*) INTO pedidos_existentes FROM Pedidos WHERE cliente_id = OLD.cliente_id; IF pedidos_existentes > 0 THEN SIGNAL SQLSTATE '45000'

Contents

More Related Answers

CREATE TRIGGER trg_excluir_cliente BEFORE DELETE ON Clientes FOR EACH ROW BEGIN DECLARE pedidos_existentes INT; SELECT COUNT(*) INTO pedidos_existentes FROM Pedidos WHERE cliente_id = OLD.cliente_id; IF pedidos_existentes > 0 THEN SIGNAL SQLSTATE '45000'

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.