Home
Learn and Earn Money
_Earn from Forex
_Affiliate Marketing
_Digital Marketing
_Email Marketing
_Freelancing
_Get Traffic
_Online Business
_Programming
_Technology
_Web Hosting
Downloads
_Ebooks
Home
About
Contact
Home
MySQL - How to temporarily disable a foreign key constraint?
MySQL - How to temporarily disable a foreign key constraint?
myblog
December 14, 2021
SET FOREIGN_KEY_CHECKS=0;
SET FOREIGN_KEY_CHECKS=1;
ALTER TABLE table_name DISABLE KEYS;
ALTER TABLE table_name ENABLE KEYS;
ALTER TABLE table_name1 DROP FOREIGN KEY fk_name1; ALTER TABLE table_name2 DROP FOREIGN KEY fk_name2;
Post a Comment
0 Comments
Powered by Blogger
January 2022
1
December 2021
11
November 2021
6
0 Comments