auto Incerment
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
Re: auto Incerment
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
Re: auto Incerment
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
Re: auto Incerment
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
Re: auto Incerment
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