[no subject]

On 9/14/05, Christopher Fowler <cfowler at outpostsentinel.com> wrote:
> Can anyone tell me how to reset an autoincrement on a table in MySQL.
> The docs tell me that it is set to max(id) on startup.  If I delete
> everything from the table and then restart the server it is as if
> the max(id) no longer reads 0.  It still reads the old value but there
> is nothing in the table.

-- 
James Sumners
<a  rel="nofollow" href="http://james.roomfullofmirrors.com/";>http://james.roomfullofmirrors.com/</a>

&quot;All governments suffer a recurring problem: Power attracts
pathological personalities. It is not that power corrupts but that it
is magnetic to the corruptible. Such people have a tendency to become
drunk on violence, a condition to which they are quickly addicted.&quot;

Missionaria Protectiva, Text QIV (decto)
CH:D 59


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<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>
</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>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00300.html">[ale] L.A.M.P. Server Setup</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00302.html">[ale] OT: Advice / help</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00298.html">[ale] Auto increment in MySQL</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00303.html">[ale] Auto increment in MySQL</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00301"><strong>Date</strong></a></li>
<li><a href="threads.html#00301"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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