Re: on delete|update--Disagreement

2003-12-03 Thread Alaios
tp://www.upscene.com - Original Message - From: Alaios To: Martijn Tonies Sent: Wednesday, December 03, 2003 4:57 PM Subject: Re: on delete|update axa!!! this works with myIsam tables? Martijn Tonies <[EMAIL PROTECTED]> wrote: Hi, > Hi there. I am trying to find what these > ON D

Re: on delete|update

2003-12-03 Thread Heikki Tuuri
Hi! - Original Message - From: ""Martijn Tonies"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 03, 2003 4:46 PM Subject: Re: on delete|update > Hi, > > > Hi there. I am trying to find what these > > ON

Re: on delete|update

2003-12-03 Thread Martijn Tonies
Hi, > Hi there. I am trying to find what these > ON DELETE NO ACTION > > ON UPDATE NO ACTION > > would provide ib my db. What are the options and what each of them do? These have to do with Foreign Key Constraints. If you're using InnoDB tables, you could let MySQL automatically drop any chil

on delete|update

2003-12-03 Thread Alaios
Hi there. I am trying to find what these ON DELETE NO ACTION ON UPDATE NO ACTION would provide ib my db. What are the options and what each of them do? - Do you Yahoo!? Free Pop-Up Blocker - Get it now

Re: FW: I need an example on DELETE /UPDATE with JOIN syntax

2002-04-30 Thread Egor Egorov
Vadim, Monday, April 29, 2002, 7:10:27 PM, you wrote: V> My company migrated to MySQL a few months ago from Sybase Adaptive V> Server Anywhere. Where I'm very impressed with the performance and the V> simplicity of management I find its very difficult, however, to run V> regular updates or delete

FW: I need an example on DELETE /UPDATE with JOIN syntax

2002-04-29 Thread Vadim
Greetings: My company migrated to MySQL a few months ago from Sybase Adaptive Server Anywhere. Where I'm very impressed with the performance and the simplicity of management I find its very difficult, however, to run regular updates or deletes because joins are not supported on delete and update

FW: I need an example on DELETE /UPDATE with JOIN syntax

2002-04-27 Thread Vadim
-Original Message- From: Vadim [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 27, 2002 4:49 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: I need an example on DELETE /UPDATE with JOIN syntax Greetings: My company migrated to MySQL a few mo

I need an example on DELETE /UPDATE with JOIN syntax

2002-04-27 Thread Vadim
Greetings: My company migrated to MySQL a few months ago from Sybase Adaptive Server Anywhere. Where I'm very impressed with the performance and the simplicity of management I find its very difficult, however, to run regular updates or deletes because joins are not supported on delete and update