Re: [PHP] mod primary key field - newbie question
Sounds like you want to set the auto increment. To do that, use this query: alter table `table_name` auto_increment 1; That will reset it to one. Although I've never tried it, I assume you can give it another value. Take care, Floyd On Jul 13, 2009, at 5:35 PM, c...@hosting4days.com wrote: newbie question ... I have a MySQL table where I want to update (renumber) the primary numeric key field. - I successfully turned field off as a primary key index and UN auto incremented it - then created new sequential numbers for it - then turned back on primary key index and re added auto increment in BUT when I make a new record it does NOT start where new numbers stop last is 51 next should be 52 but jumps to 157 Q: is there a way to reset the NEXT SERIAL ID NUMBER somewhere? how do I fix this? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mod primary key field - newbie question
On Mon, Jul 13, 2009 at 17:35, c...@hosting4days.comc...@hosting4days.com wrote: newbie question ... I have a MySQL table where I want to update (renumber) the primary numeric key field. The response you received from Floyd was accurate, but next time, please keep these kinds of questions on the appropriate lists. This wasn't on-topic or PHP-related, but instead should've been asked on the MySQL list at my...@lists.mysql.com. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Check out our great hosting and dedicated server deals at http://twitter.com/pilotpig -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mod primary key field - newbie question
-Original Message- From: Floyd Resler [mailto:fres...@adex-intl.com] Sent: Monday, July 13, 2009 5:41 PM To: c...@hosting4days.com Cc: php-general@lists.php.net Subject: Re: [PHP] mod primary key field - newbie question Sounds like you want to set the auto increment. To do that, use this query: alter table `table_name` auto_increment 1; That will reset it to one. Although I've never tried it, I assume you can give it another value. Take care, Floyd On Jul 13, 2009, at 5:35 PM, c...@hosting4days.com wrote: newbie question ... I have a MySQL table where I want to update (renumber) the primary numeric key field. - I successfully turned field off as a primary key index and UN auto incremented it - then created new sequential numbers for it - then turned back on primary key index and re added auto increment in BUT when I make a new record it does NOT start where new numbers stop last is 51 next should be 52 but jumps to 157 Q: is there a way to reset the NEXT SERIAL ID NUMBER somewhere? how do I fix this? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] alter table `table_name` auto_increment 1; Correct you can give it any value you wish it to start FROM. ie if you pass 51 as the value then the next will be Auto increment value will be 52 __ Information from ESET Smart Security, version of virus signature database 4240 (20090713) __ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
