If you have a column defined as auto_increment, there must be a key on it.
This is true both in myisam and innodb.
If you need further help, please show us the full structure of the real table
you're operating on (not the one from your sandbox), the statement you run, and
the error message.
R
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 or
3, 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&#x
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,
Fre
"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
&g
Tuuri <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 14, 2002 8:08 AM
Subject: Re: Converting MyISAM to InnoDB
> Hi there,
>
> I just created an InnoDB table mirroring the schema of the original
table...
>
> But, I am getting the following...
>
&
ABLE (MYD +MYI) is ~ 150MB
- Original Message -
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: "ImpactNET - Edgar R Gutierrez" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 9:15 PM
Subject: Re: Converting MyISAM to InnoDB
> Hi!
&
Hi!
You should add a new data file as explained in section 5 of
http://www.innodb.com/ibman.html.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See http://www.inno
