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

Foreign Key Restriction

2005-05-03 Thread Oliver Hirschi
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 turn off the foreign key restriction in mySQL 4.1.1? Thanks. -- Oliver Hirschi http