HI Paul
Thank you very much!!!
yes it works when I have PRIMARY KEY (SoftwareId, id)
but didn't work for KEY(SoftwareId, id), since this allows to have
multiple entries on the keys, I think
vinita
Paul DuBois wrote:
> At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote:
>
>> HI
>>
>> I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33
>>
>> This is the definition of table software_machineOSs
>> +------------+----------+------+--------+---------+----------------+
>> | Field | Type | Null | Key | Default |
>> Extra |
>> +------------+----------+-------+-------+---------+----------------+
>> | softwareID | char(20) | YES | MUL | NULL
>> | |
>> | id | int(2) | | | NULL
>> | auto_increment |
>
>
>
> I assume that you have a PRIMARY KEY or UNIQUE index on
> (softwareID, id) here?
>
> What's the table type? Not all table types support composite keys
> with AUTO_INCREMENT this way.
>
>
>> | osName | char(20) | YES | | NULL
>> | |
>> | osRevision | char(20) | YES | | NULL
>> | |
>> +------------+----------+-------+-------+-----------+------------------+
>>
>> Adding an entry
>> mysql> insert into software_machineOSs (softwareID, id, osName,
>> osRevision)
>> -> values ("readline-4.3", NULL, "test", "test3");
>>
>> Selecting entries
>> mysql> select * from software_machineOSs where
>> softwareid="readline-4.3";
>> +--------------+----+---------------+------------+
>> | softwareID | id | osName | osRevision |
>> +--------------+----+---------------+------------+
>> | readline-4.3 | 1 | Tru64 | 5.1 |
>> | readline-4.3 | 1 | Solaris/Sparc | 8 |
>> | readline-4.3 | 1 | Solaris/x86 | 8 |
>> | readline-4.3 | 1 | test | test |
>> | readline-4.3 | 1 | test | test1 |
>> | readline-4.3 | 1 | test | test1 |
>> | readline-4.3 | 1 | test | test3 |
>> +--------------+----+---------------+------------+
>> 7 rows in set (0.00 sec)
>>
>>
>> As you can see the ID did NOT increment, I'm not sure what I'm doing
>> wrong. I tried with out giving any value for ID, 0 value for ID &
>> NULL for ID. Non of them seems working. Is this a bug in the version
>> 3.23.33??
>>
>> Appreciate your fast response & Thank you for your time
>>
>> warm regards
>> Vinita
>
>
>
---------------------------------------------------------------------
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