I have two tables, table1
is the parent table with a column ID
and table2
with a column IDFromTable1
(not the actual name) when I put a FK on IDFromTable1
to ID
in table1
I get the error Foreign key constraint is incorrectly formed error
. I would like to delete table 2 record if table1
record gets deleted. Thanks for any help
ALTER TABLE `table2`
ADD CONSTRAINT `FK1`
FOREIGN KEY (`IDFromTable1`) REFERENCES `table1` (`ID`)
ON UPDATE CASCADE
ON DELETE CASCADE;
Let me know if any other information is needed. I am new to mysql