[EMAIL PROTECTED] ("Phil Butterworth") wrote in
news:[EMAIL PROTECTED]: 

> Is their a way to disable constraints for the new
> tables, then when all the tables are created the FK's are put into
> place, so no create table statement errors because of FK's, and no
> editing the sql dump?

SET FOREIGN_KEY_CHECKS=0;

-- do your stuff

SET FOREIGN_KEY_CHECKS=1;

-- 
felix

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to