MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftKey Cookbooks

Adding foreign key to an existing table Changing the primary key Referencing column and referenced column are incompatible Searching all foreign keys to a table or column Temporarily disabling a foreign key constraint

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

Temporarily disabling a foreign key constraint in MySQL

schedule Aug 10, 2023

Last updated

local_offer

MySQL

Tags

tocTable of Contents

expand_more

mode_heat

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

We can temporarily disable foreign key constraints on a session level in MySQL by using the below:


        
        
            
                
                
                    SET FOREIGN_KEY_CHECKS = 0;

However, make sure to restore the foreign key constraints once you are finished:


        
        
            
                
                
                    SET FOREIGN_KEY_CHECKS = 1;

MySQL | Foreign keys

A foreign key in MySQL refers to a column (or a group of columns) in one table that refers to the primary key in another table. The table containing the foreign key is referred to as the child table, while the table containing the primary key being referred to is called the parent table.

chevron_right

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!

Temporarily disabling a foreign key constraint in MySQL

Related