: 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
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,
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
Hi Matt. Thanks a lot again !
It worked pretty good.
There is no problem about the app, because
the use of the indexes is in charge of the DBMS (MySQL). The
app doesn't know about the tables and indexes details.
Best Regards,
Fred.
Hi Fred,
Also, you may be able to swap the order