At 01:02 AM 3/13/2002, you wrote:
>Greetings!!!
>
>I would just like to know if the following is normal:
>
>I created a file TRANSACTION_LOG.sql to create an InnoDB table with MULTIPLE
>KEYs with one AUTO COLUMN.
>
>The file consists of the following SQL commands:
>
>drop table TRANSACTION_LOG;
>create table TRANSACTION_LOG (SESSION_ID int(10) not null, TRANS_CODE int(5)
>not null, TRANS_LOG_ID int(10) not null auto_increment, primary key
>(TRANS_CODE,TRANS_LOG_ID)) TYPE = InnoDB;
>
>Unfortunately , I get the following error:
>
>
>[root@oracle /root]# mysql accounting < TRANSACTION_LOG.sql
>ERROR 1075 at line 2: Incorrect table definition; There can only be one auto
>column and it must be defined as a key
>
>Does InnoDB tables support MULTIPLE KEYS with an AUTO COlumn?
Edgar,
Not officially. The InnoDb manual states auto-increment fields
must be in a key by themselves. :-(
But I've discovered you can have a compound index with an
auto-increment field as long as the auto-increment field is the *first*
field of the index. So if you switch your primary key to
primary key (TRANS_LOG_ID,TRANS_CODE)
it should work. :-)
Brent
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
