Chris W wrote:
Mark Goodge wrote:
On a more general note, if the actual value of the primary key matters
for anything other than simply existing as a primary key, then you
shouldn't be using auto-increment at all. You should generate the
value through some other means and insert it with the v
Mark Goodge wrote:
On a more general note, if the actual value of the primary key matters
for anything other than simply existing as a primary key, then you
shouldn't be using auto-increment at all. You should generate the
value through some other means and insert it with the value that you
w
abhishek jain wrote:
On Sat, Aug 2, 2008 at 10:49
But as per a thread on this link, if the resetted value is less than the
highest value already in table then the effective increment value will start
from highest number and not from 100.
I have deleted some rows and i want the increment to start
On Sat, Aug 2, 2008 at 10:49 PM, Nacho Garcia <[EMAIL PROTECTED]> wrote:
> http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
>
> mysql> *ALTER TABLE tbl AUTO_INCREMENT = 100;*
>
>
>
> On Sat, Aug 2, 2008 at 5:28 PM, abhishek jain <[EMAIL PROTECTED]> wrote:
>
>> Hello friends,
>> I
At 21:00 -0500 12/29/02, Carlin Anderson wrote:
I have a number of databases installed under mysql 3.23 and 4.0, and
will need to occasionally re-initialize certain tables. Can I
re-set auto-increment fields within those tables?
You can drop and re-create the tables. This will work for any ta
At 6:03 PM -0500 9/25/01, [EMAIL PROTECTED] wrote:
>Hi All,
>
>I seen a post a few days ago on how to set the auto increment value
>back to one
>after deleting all the data from a table. I suppose I could just re-create the
>table, but thought it be simpler to just alter the table to reset the au
I just saw this in the manual and think it can do what you need:
It's an option of the myisamchk program
--set-auto-increment[=value]
Force auto_increment to start at this or higher value. If no value is given,
then sets the next auto_increment value to the highest used value for the
auto key +
