Where error in add FOREIGN KEY in phpmyadmin?

Question

Possible Duplicate:
Setting up foreign keys in phpMyAdmin?

ALTER table podcategory add FOREIGN KEY (category_id) 
           REFERENCES category(category_id)
ON UPDATE RESTRICT
ON DELETE CASCADE

When i send script in phpmyadmin i get error

Can't create table './C292729_T25027/#sql-be0_30ed238.frm' (errno: 150)

How to add this FOREIGN KEY?

make sure your db engine is `InnoDB` and reference column is `indexed` column. check this answer [setup foreign key](http://stackoverflow.com/a/6244893/1225337) — Nikson Kanti Paul, Nov 13 '12 at 08:22

score 0 · Answer 1 · edited May 23 '17 at 12:27

0

try this type:

ALTER TABLE `aaaa` ADD CONSTRAINT fk_comp_id FOREIGN KEY ( `comp_id` ) REFERENCES `comps` ( `id` );

Or this SO answer/question might be able to help you out for sure: Setting up foreign keys in phpMyAdmin?

edited May 23 '17 at 12:27

Community

answered Nov 13 '12 at 08:15

Rob

an example, you can replace it by your own index as you like. – Rob Nov 13 '12 at 08:22
#1005 - Can't create table './C292729_T25027/#sql-be0_30ee499.frm' – Strannik Nov 13 '12 at 08:25
here `fk_comp_id` is the name of the `index`, – Nikson Kanti Paul Nov 13 '12 at 08:25
@strannik for the 1005 error, check out this item: http://stackoverflow.com/questions/9937490/mysql-error-1005-cant-create-table-errno-150-when-i-try-create-more-tha – Rob Nov 13 '12 at 08:28

1 Answers1