ERROR 1442
My problem is:
When I insert into base1.Client I want to insert into base2.Client.
When I insert into base2.Client, I want to insert into base3.Client.
When I insert into base3.Cliente I want to insert into base2.client.
When I insert into base2.Client, I want to insert into base1.Client.
But this error don't let me go...
Script:
INSERT INTO banco3.Clientes VALUES (6,'RoseMel', '1998-05-08', '48381856' '4539-6', 'ananana', 'oqe?', '162', 'sasnaush', 'qsjqijqiwj',
'SP', '13720000');
DELIMITER $$
CREATE TRIGGER insereBanco3 AFTER INSERT
ON banco3.clientes FOR EACH ROW
BEGIN
INSERT INTO banco2.cli(id, nome, dat_nascimento, cpf, rg, endereco, numero, bairro, cidade, estado, cep)
VALUES(NEW.id, NEW.nome, NEW.dat_nascimento, NEW.cpf, NEW.rg, NEW.endereco, NEW.numero, NEW.bairro, NEW.cidade, NEW.estado, NEW.cep);
END;