887
2019-04-19 03:47:10
SET foreign_key_checks = 0;
That will prevent MySQL from checking foreign keys. Make sure to set it back to 1 when you are done though.
Also, you could always drop the foreign key and then add it later if you wanted to only affect a singular key
ALTER TABLE tableName DROP FOREIGN KEY fk;
热门帖子
热门github
6
i guess you don't have to set foreign key check back to 1 if you're immediately logging out of the session.
i have multiple table so i want to delete this field from all table so how can i do this. this will not working
Bear in mind that this will leave orphaned rows, it doesn't force delete any child records.