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 |
> | 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
