Re: Foreign Key Restriction

2005-05-06 Thread Michael Stassen
Oliver Hirschi wrote: "Partha Dutta" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] You can turn off foreign key restrictions within your session: SET SESSION foreign_key_checks = 0; Then later, turn them back on using SET SESSION foreign_key_checks = 1; I saw, that the tables o

Re: Foreign Key Restriction

2005-05-06 Thread Oliver Hirschi
"Partha Dutta" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > You can turn off foreign key restrictions within your session: > > SET SESSION foreign_key_checks = 0; > > Then later, turn them back on using > > SET SESSION foreign_key_checks = 1; > I saw, that the tables on my

RE: Foreign Key Restriction

2005-05-04 Thread Partha Dutta
/certification > -Original Message- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Oliver Hirschi > Sent: Wednesday, May 04, 2005 10:50 AM > To: mysql@lists.mysql.com > Subject: Re: Foreign Key Restriction > > "Oliver Hirschi" <[EMAIL PROTECTED]> schrieb i

Re: Foreign Key Restriction

2005-05-04 Thread Oliver Hirschi
"Oliver Hirschi" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hi > > I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign key > retrictions. > > Is it right, that mySQL 4.1.x has something changed due to the foreign > key restriction? > Is there an option to tu