phpmyadmin不允许我添加主/外键关系

Question

That is the primary table field (tasks table):

task_id int(10)     UNSIGNED    No  None    AUTO_INCREMENT

This is my foreign table field (url_error_stats table):

task_id int(10)     UNSIGNED    No  None    

url_error_stats doesnt present the "relation view" option to connect between the keys..why?

SQL query:

ALTER TABLE url_error_stats ADD FOREIGN KEY ( task_id ) REFERENCES aws_backlinks.tasks (

task_id ) ON DELETE CASCADE ON UPDATE CASCADE ;

MySQL said:

1452 - Cannot add or update a child row: a foreign key constraint fails (aws_backlinks., CONSTRAINT #sql-6f0_3bd_ibfk_1 FOREIGN KEY (task_id) REFERENCES tasks (task_id) ON DELETE CASCADE ON UPDATE CASCADE)

Answer 1

you have to use innodb and index the primary key if you want to create the foreign keys. and I will recommend you to use NAVICAT . its much easier to create foreign keys and quick too. but for a quick phpmyadmin guide see

Setting up foreign keys in phpMyAdmin?