MyISAM supports foreign keys doesn't it? Martijn Tonies <[EMAIL PROTECTED]> wrote:No. MyISAM tables don't support foreign keys. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://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 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 child objects by using ON DELETE CASCADE. NO ACTION will raise an exception if there are child objects and you're trying to delete/update a parent row. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Do you Yahoo!? Free Pop-Up Blocker - Get it now --------------------------------- Do you Yahoo!? Free Pop-Up Blocker - Get it now