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