MySQL question - GoFuckYourself.com

biskoppen · 07-01-2007, 05:36 PM

Let's say I have a table with an auto_increment field called "id"..

This table got 5 rows.. where "id" goes from 1-5..

Now I delete row 4 and 5..

The next row I insert will get "id" = 6...

How do I get it do let the next "id" to start at 4 which is the highest available number?

(Don't ask why I need that

)

budz · 07-01-2007, 05:38 PM

I use navicat.. you can edit anything in your table manually.

but I'd like to know how to automate this because that is annoying when you delete records

Donkey Punch · 07-01-2007, 05:51 PM

Quote:

INNODB tables store the auto increment id in the MYI file. Even if you delete rows and restart the server MySQL will not reuse the id. The same is true for innodb.

from gooooogle serps

k0nr4d · 07-01-2007, 05:55 PM

i think 'OPTIMIZE' does that. google it, im not positive

biskoppen · 07-01-2007, 05:57 PM

Quote:

Originally Posted by k0nr4d

i think 'OPTIMIZE' does that. google it, im not positive

Hmm... actually think I heard about that some years ago... will investigate that

Alky · 07-01-2007, 06:03 PM

why even use the auto increment feature then? just use your own id #'s

biskoppen · 07-01-2007, 06:15 PM

Quote:

Originally Posted by Alky

why even use the auto increment feature then? just use your own id #'s

Yeah, that was mine conclusion too... changing it right now.. (Thanks though)

07-01-2007, 05:36 PM	#1
biskoppen Confirmed User Join Date: Mar 2003 Location: Very small penis Posts: 5,809	MySQL question Let's say I have a table with an auto_increment field called "id".. This table got 5 rows.. where "id" goes from 1-5.. Now I delete row 4 and 5.. The next row I insert will get "id" = 6... How do I get it do let the next "id" to start at 4 which is the highest available number? (Don't ask why I need that ) __________________ Submit my videos to make bank, tons of 5 minute videos offered right here

07-01-2007, 05:38 PM	#2
budz Disruptive Innovator Industry Role: Join Date: Sep 2003 Location: Vegas Posts: 4,230	I use navicat.. you can edit anything in your table manually. but I'd like to know how to automate this because that is annoying when you delete records __________________ C:\Code\ C:\Code\Run\

07-01-2007, 05:55 PM	#4
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,231	i think 'OPTIMIZE' does that. google it, im not positive __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development

07-01-2007, 06:03 PM	#6
Alky Confirmed User Join Date: Apr 2002 Location: Houston Posts: 5,651	why even use the auto increment feature then? just use your own id #'s