Hi Well... I tried all the methodes, tried inserting with out the id, with NULL id & with 0 as id. No of them seems working :-( Any other ideas??
Thanks you Arjen van der Weijden wrote: >Leave out the id column in your insert-statement > > > > > > vinita vigine > > Murugiah To: [EMAIL PROTECTED] > > <[EMAIL PROTECTED] cc: > > .OZ.AU> Subject: auto Incerment > > > > 18-09-02 > > 08:25 > > > > > > > > > > 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 | >| 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 > > > > > > --------------------------------------------------------------------- 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