Disabling Foreign Key Checks

Problem

During a massive data migration, you need to import bulk data that has circular relationships, causing foreign key errors. The DBA suggests temporarily disabling foreign key checks to perform the load. Write a query that outputs command with the value: "SET foreign_key_checks = 0; disables foreign key constraints during bulk loading in MySQL/DuckDB."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution