[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] Auto increment in MySQL

Subject: [ale] Auto increment in MySQL
From: cfowler at outpostsentinel.com (Christopher Fowler)
Date: Wed, 14 Sep 2005 22:34:48 -0400
In-reply-to: <[email protected]>
References: <[email protected]> <[email protected]> <[email protected]>

On Wed, 2005-09-14 at 21:34 -0400, George Carless wrote:
> ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234
> 

Here is a question.  Lets say that I have a bunch of holes because I
deleted various rows.  can I set the value to 1 and MySQL will be smart
enough to fill those holes?

Follow-Ups:
- [ale] Auto increment in MySQL
  - From: me at grantrobertson.com (Grant Robertson)
- [ale] Auto increment in MySQL
  - From: jkinney at localnetsolutions.com (James P. Kinney III)
- [ale] Auto increment in MySQL
  - From: groups at changinglinks.com (ChangingLINKS.com)

References:
- [ale] Auto increment in MySQL
  - From: cfowler at outpostsentinel.com (Christopher Fowler)
- [ale] Auto increment in MySQL
  - From: james.sumners at gmail.com (James Sumners)
- [ale] Auto increment in MySQL
  - From: kafka at antichri.st (George Carless)

Prev by Date: [ale] anyone running "R"
Next by Date: [ale] anyone running "R"
Previous by thread: [ale] Auto increment in MySQL
Next by thread: [ale] Auto increment in MySQL
Index(es):
- Date
- Thread