Re: Re: auto-increment usage question
Richard, Thursday, July 11, 2002, 7:26:00 PM, you wrote: RF But the default table type is already MyISAM If you didn't set up another default table type. Please, show us the output of SHOW TABLE STATUS LIKE your_table_name; Can you create a repeatable testcase? And some more info.. What version of MySQL do you use? and what OS do you use? That is the normal behavior for ISAM type files. Convert them to MYISAM. Richard Fox wrote: Hi, I have a mysql table which has a run_id which together with user_id RF forms the primary key for the table. run_id is not null and auto-increment. I RF delete records from this table, and add new records. I want the run_id to keep incrementing and not reuse values, but here is the actual behavior: When records are deleted, upon the next insert run_id will be given RF a value which is one higher than the greatest value remaining in the RF table. If the table is empty, run_id will be assigned '1'. Is there any way in which I can get run_id to keep incrementing and not RF be based on the current highest value in the table, but on the last RF assigned run_id even if that record has been deleted? If not, are there any common workarounds? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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-increment usage question
I verified his problem with 3.23.38 here using myisam files. The key here is that the unique index is across TWO integer fields, one of which is auto_increment. Victoria Reznichenko wrote: Richard, Thursday, July 11, 2002, 7:26:00 PM, you wrote: RF But the default table type is already MyISAM If you didn't set up another default table type. Please, show us the output of SHOW TABLE STATUS LIKE your_table_name; Can you create a repeatable testcase? And some more info.. What version of MySQL do you use? and what OS do you use? That is the normal behavior for ISAM type files. Convert them to MYISAM. Richard Fox wrote: Hi, I have a mysql table which has a run_id which together with user_id RF forms the primary key for the table. run_id is not null and auto-increment. I RF delete records from this table, and add new records. I want the run_id to keep incrementing and not reuse values, but here is the actual behavior: When records are deleted, upon the next insert run_id will be given RF a value which is one higher than the greatest value remaining in the RF table. If the table is empty, run_id will be assigned '1'. Is there any way in which I can get run_id to keep incrementing and not RF be based on the current highest value in the table, but on the last RF assigned run_id even if that record has been deleted? If not, are there any common workarounds? - 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-increment usage question
But the default table type is already MyISAM That is the normal behavior for ISAM type files. Convert them to MYISAM. Richard Fox wrote: Hi, I have a mysql table which has a run_id which together with user_id forms the primary key for the table. run_id is not null and auto-increment. I delete records from this table, and add new records. I want the run_id to keep incrementing and not reuse values, but here is the actual behavior: When records are deleted, upon the next insert run_id will be given a value which is one higher than the greatest value remaining in the table. If the table is empty, run_id will be assigned '1'. Is there any way in which I can get run_id to keep incrementing and not be based on the current highest value in the table, but on the last assigned run_id even if that record has been deleted? If not, are there any common workarounds? TIA Rich sql, query - 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 - 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-increment usage question
Hi, I have a mysql table which has a run_id which together with user_id forms the primary key for the table. run_id is not null and auto-increment. I delete records from this table, and add new records. I want the run_id to keep incrementing and not reuse values, but here is the actual behavior: When records are deleted, upon the next insert run_id will be given a value which is one higher than the greatest value remaining in the table. If the table is empty, run_id will be assigned '1'. Is there any way in which I can get run_id to keep incrementing and not be based on the current highest value in the table, but on the last assigned run_id even if that record has been deleted? If not, are there any common workarounds? TIA Rich sql, query - 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-increment usage question
That is the normal behavior for ISAM type files. Convert them to MYISAM. Richard Fox wrote: Hi, I have a mysql table which has a run_id which together with user_id forms the primary key for the table. run_id is not null and auto-increment. I delete records from this table, and add new records. I want the run_id to keep incrementing and not reuse values, but here is the actual behavior: When records are deleted, upon the next insert run_id will be given a value which is one higher than the greatest value remaining in the table. If the table is empty, run_id will be assigned '1'. Is there any way in which I can get run_id to keep incrementing and not be based on the current highest value in the table, but on the last assigned run_id even if that record has been deleted? If not, are there any common workarounds? TIA Rich sql, query - 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