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.
: 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
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
) 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!
You should add a new data file as explained in section 5
[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...
mysql insert into NEW_TABLE select * from