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: reset auto increment to a lesser value

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 on this link, if the resetted value is less than the highest value already in table then the effective increment value will start

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

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

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

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 in it remember the old

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. from manual : Truncate

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 the table,

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. from manual :

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,

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

RE: Reset Auto Increment

+ 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 all

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 auto

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

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]

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 existing