[ale] Auto increment in MySQL

[James Sumners]

I believe you will have to drop the table and re-create it.

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
http://james.roomfullofmirrors.com/

"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."

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