From: Tom Ray [Lists]
Date: June 23 2006 3:35pm
Subject: Re: Autoindexing
List-Archive: http://lists.mysql.com/mysql/199244
Message-Id: <449C0A3A.7080907@blazestudios.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 7bit

Well I believe I'll need to update mysql since I just realized this 
server is using 3.23. Gotta love taking something over from someone and 
finding out they weren't very good at the job to begin with.

Karl Larsen wrote:
>    Hi Remo, your method works fine on version 4.1 and the one shown 
> for version 5 does not work here. Nice to know there is a SQL word 
> AUTO_INCREMENT  to do the job.
>
> Karl
>
>
>
> Remo Tex wrote:
>>     If you are using autoincrement filed you could try this:
>> ALTER TABLE `my_database`.`my_table` AUTO_INCREMENT = 201;
>>
>>     ...or else if it is some stored proc you should find and edit 
>> table where it sotres index/counter data..
>>
>> Tom Ray [Lists] wrote:
>>> Hey, I have a really simple question (I hope)..I have a database 
>>> that has a field in it that autoindexes the number. I screwed up and 
>>> imported a bunch of wrong data. Up to row 200 it's right, beyond 
>>> that it was wrong so I had delete it all. The problem now is the 
>>> autoindexing is set to 1105, I want to change it so the next insert 
>>> gets a number of 201 not 1105.
>>>
>>> I've tried to change it via phpMyAdmin but it keeps going back to 
>>> 1105. Is there anyway I can do this?
>>
>
>