I want to delete foreign key value in mysql table

[malatamil]

i have two tables. in 2nd table i assigned the 1st table primary key as foreign key.

i have two options edit and delete. i can't delete foreign key value and also primary key value in 2nd table.

[mangel.murti]

you can not remove or delete foreign key data on table 2 which relate both tables. in other words data consistancy Maintaine by PK FK in tables. you have to remove first foreign key constraint.

[network18]

you can try to do that by executing below query first - SET foreign_key_checks = 0;

[Taywin]

Are you talking about deleting a row in the 1st table, so the data in 2nd table should be removed as well???

[mangel.murti]

yes. i think that is good way. you can also re-insert data to your tables.