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