给mysql表添加外键_如何在MySQL表中添加外键？

I use MySQL with InnoDB engine. I double-checked type of columns. But always have:

Error Code: 1215. Cannot add foreign key constraint

I tried:

ALTER TABLE `mail`.`boxes`

ADD CONSTRAINT FK_id

FOREIGN KEY (id)

REFERENCES `mail`.`users` (id)

ON UPDATE NO ACTION

ON DELETE NO ACTION;

and

ALTER TABLE `mail`.`boxes`

ADD FOREIGN KEY (id)

REFERENCES `mail`.`users` (id)

Nothing works(((

Please, help, what I am doing wrong (except choosing MySQL :-) )?

解决方案

If table contains data then you are not able to add foreign key you drop table object and recreate

use below reference for the same