set_foreign_key_checks mysql code example

Example 1: mariadb disable foreign key checks

SET FOREIGN_KEY_CHECKS=0;

Example 2: foreign_key_checks

-- Specify to check foreign key constraints (this is the default)
    SET FOREIGN_KEY_CHECKS = 1;
 
   -- Do not check foreign key constraints
    SET FOREIGN_KEY_CHECKS = 0;