Hi Fred, Also, you may be able to swap the order of those columns in the index. I think that would work, but don't know if it would cause other problems -- like for the way your app uses the index, etc.
Matt ----- Original Message ----- From: "Fred" Sent: Saturday, January 03, 2004 6:11 PM Subject: Re: Converting MyISAM to InnoDB type. > Hi Matt and thank you very much !!!! > > Now I get the point .... I'll have to decide if I maintain these > two tables in MyISAM or if I drop the AUTO_INCREMENT and > change the source-code in Delphi. > > It's clear now that the problem is the lack of support of InnoDB. > > Thanks for your help and regards, > Fred. > > > Hi Fred, > > > > InnoDB does not support AUTO_INCREMENT on secondary columns of a > > multi-column index. > > > > > `id_registro` int(11) NOT NULL auto_increment, > > > PRIMARY KEY (`id_formula`,`id_registro`) > > > > There: id_registro is the second column of the index. > > > > > > Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
