Re: reset auto increment to a lesser value

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

Re: reset auto increment to a lesser value

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

Re: reset auto increment to a lesser value

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

Re: reset auto increment to a lesser value

ECTED]> wrote: > >> Hello friends, >> I need to reset auto increment to a lesser value, is there a metod to do >> so >> in any version of mysql. >> Pl. help me. >> Thanks >> abhi >> > > Hi Nacho, Thanks for the reply, But as per a thread

reset auto increment to a lesser value

Hello friends, I need to reset auto increment to a lesser value, is there a metod to do so in any version of mysql. Pl. help me. Thanks abhi

Re: Truncate do not reset auto increment counter

"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote: >> "Kim G. Pedersen" <[EMAIL PROTECTED]> wrote: >>> >>> I once red that using "truncate table xx" instead of "delete from xx" >>> should reset autoincrement , but it seem not to happend. >>> >>> but when I try to insert data with "insert" or "load data

Re: Truncate do not reset auto increment counter

> "Kim G. Pedersen" <[EMAIL PROTECTED]> wrote: >> >> I once red that using "truncate table xx" instead of "delete from xx" >> should reset autoincrement , but it seem not to happend. >> >> but when I try to insert data with "insert" or "load data in " >> it remember the old autoincrement value. >

Re: Truncate do not reset auto increment counter

"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote: > > I once red that using "truncate table xx" instead of "delete from xx" > should reset autoincrement , but it seem not to happend. > > but when I try to insert data with "insert" or "load data in " > it remember the old autoincrement value. > > fr

Truncate do not reset auto increment counter

hello I once red that using "truncate table xx" instead of "delete from xx" should reset autoincrement , but it seem not to happend. but when I try to insert data with "insert" or "load data in " it remember the old autoincrement value. from manual : "Truncate operations drop and re-create th

Re: reset auto-increment value

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

reset auto-increment value

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? Thanks Carlin Anderson - Before posting, ple

Re: Reset Auto Increment

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

RE: Reset Auto Increment

o key + 1. Hope it helps John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 September 2001 00:03 To: [EMAIL PROTECTED] Subject: Reset Auto Increment Hi All, I seen a post a few days ago on how to set the auto increment value back to one after deleting al

Reset Auto Increment

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 auto increment value back to 1. what exactly is the "alter"

Re: trying to reset auto-increment

At 11:05 PM -0400 9/16/01, <[EMAIL PROTECTED]> wrote: >I manually entered into my database several rows with high values in the >auto-increment column. I subsequently deleted the high value rows. I now >am trying to reset the auto-increment. How do I reset it to the Max of >the currently existi

trying to reset auto-increment

I manually entered into my database several rows with high values in the auto-increment column. I subsequently deleted the high value rows. I now am trying to reset the auto-increment. How do I reset it to the Max of the currently existing values? -matt [EMAIL PROTECTED] ==