[no subject]

-G

On 9/14/05, Christopher Fowler <cfowler at outpostsentinel.com> wrote:
> 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?


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00310" href="msg00310.html">[ale] Auto increment in MySQL</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00298" href="msg00298.html">[ale] Auto increment in MySQL</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
<li><strong><a name="00301" href="msg00301.html">[ale] Auto increment in MySQL</a></strong>
<ul><li><em>From:</em> james.sumners at gmail.com (James Sumners)</li></ul></li>
<li><strong><a name="00303" href="msg00303.html">[ale] Auto increment in MySQL</a></strong>
<ul><li><em>From:</em> kafka at antichri.st (George Carless)</li></ul></li>
<li><strong><a name="00306" href="msg00306.html">[ale] Auto increment in MySQL</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00299.html">[ale] anyone running &quot;R&quot;</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00309.html">[ale] Auto increment in MySQL</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00306.html">[ale] Auto increment in MySQL</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00310.html">[ale] Auto increment in MySQL</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00308"><strong>Date</strong></a></li>
<li><a href="threads.html#00308"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>