advanced code snippet search

Posted By

pointer on 11/24/08


Tagged

mysql sql


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

katsuke


MySQL disable foreign key constraint check

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. mysql> SET FOREIGN_KEY_CHECKS = 0;
  2. mysql> SOURCE dump_file_name;
  3. mysql> SET FOREIGN_KEY_CHECKS = 1;

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: katsuke on February 19, 2011

To give a bit of background

source: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvarforeignkey_checks

You need to login to post a comment.