Creating SQL foreign key

Asked Jun 09 '22 at 07:33

Active Jun 10 '22 at 04:27

Viewed 45 times

Am trying to reference admins table to activity log table but it is failing yet i have correctly formed it.

BELOW IS THE SQL ERROR

Error

SQL query:

ALTER TABLE activity_log_admins ADD FOREIGN KEY (adminid) REFERENCES admins(adminid)

MySQL said: Documentation
#1005 - Can't create table `miu`.`activity_log_admins` (errno: 150 "Foreign key constraint is incorrectly formed")

Please help me how to figure it out?

edited Jun 09 '22 at 07:33

jarlh

42,561
8
45
63

asked Jun 09 '22 at 07:33

Ngode Danuel

1

Show us admins and activity_log_admins table definitions. – jarlh Jun 09 '22 at 07:34
Is your column adminid in table admins primary key ? – VBoka Jun 09 '22 at 07:41
Either the datatypes are not the same or the tables contains the data which contradicts this relation. – Akina Jun 09 '22 at 07:44
adminid is the primary key in the admins table – Ngode Danuel Jun 09 '22 at 07:44
Please add both table definitions or read the manual and figure it out https://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html – P.Salmon Jun 09 '22 at 07:48
https://stackoverflow.com/questions/8434518/mysql-foreign-key-constraint-is-incorrectly-formed-error – petunse Jun 09 '22 at 07:59
Thanks stackoverflow article was usefull by just changing parent table to InnoDB Engine ALTER TABLE parent_table ENGINE=InnoDB; – Ngode Danuel Jun 09 '22 at 08:28

Creating SQL foreign key

0 Answers0