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 ----- Original Message ----- From: "Fred" Sent: Saturday, January 03, 2004 5:38 PM Subject: Re: Converting MyISAM to InnoDB type. > > > > > > If you change the Type=MyISAM to Type=InnoDB and execute the > > create query, what message do you get? > > > > Hi you all ...... again .... > > This is the error message I get if I try to create > this table in InnoDB type. > > CREATE TABLE `test' ( > `id_formula` int(11) NOT NULL default '0', > `tp_posologia` int(11) default NULL, > `qt_dias` int(11) default NULL, > `id_registro` int(11) NOT NULL auto_increment, > PRIMARY KEY (`id_formula`,`id_registro`) > ) TYPE=InnoDB DEFAULT CHARSET=latin1; > > [EMAIL PROTECTED]:3306] ERROR 1075: Incorrect table definition; > There can only be one auto column and it must be defined as a key > > If I drop the AUTOINCREMENT, I can change the table type, but > in this case, I will have to change the application source-code in > Delphi. > > Thanks, > Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
