disabling foreign key constraints

disabling foreign key constraints

am 12.08.2004 15:13:49 von Dave Howorth

I have two records with interlinked fields and foreign key constraints.
To insert the records, I need to turn off the constraint.

In the mysql command-line client I would do this by typing:
SET FOREIGN_KEY_CHECKS = 0;
and
SET FOREIGN_KEY_CHECKS = 1;
once the fields were consistent again.

How do I do this from Perl?

Thanks, Dave
--
Dave Howorth
MRC Centre for Protein Engineering
Hills Road, Cambridge, CB2 2QH
01223 252960


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org