ERROR 1215: Can not add foreign key constraint (MySQL Workbench)

Question

ERROR 1215: Can not add foreign key constraint (MySQL Workbench)

Navigation

#1 by (1 votes)

0

Hello, I'm trying to add a foreign key to a table but I get error 1215. I've already checked the attributes and all are compatible, the wallet field is a primary key, I do not understand why it's not possible to add the key.

ALTER TABLE 'acoes_db'.'Carteira' 
ADD CONSTRAINT 'carteira_fk'
  FOREIGN KEY ('ID')
  REFERENCES 'acoes_db'.'Acionistas' ('Carteira')
  ON DELETE CASCADE
  ON UPDATE CASCADE;

mysql sql mysql-workbench foreign-key

asked by anonymous 18.04.2018 / 08:41

1 answer

Copy data from one worksheet to another Block an element within the textarea

score 1 · Answer 1

As the name suggests, the Foreign Key (foreign key) is the column (s) that identifies the parent in the child table.

You are trying to add FK in the parent reference of the daughter table (the opposite scenario).

Try to do this:

ALTER TABLE 'acoes_db'.'Acionistas' 
    ADD CONSTRAINT 'carteira_fk'
    FOREIGN KEY ('Carteira')
    REFERENCES 'acoes_db'.'Carteira' ('ID');