On or about Tue, Jul 16, 2002 at 05:00:58PM +0100, Paul Makepeace typed: >An alternative way is to "delete from table_name" (if you're too lazy to >drop and rebuild) which will reset the auto_increment. This seems to be >a special case -- deleting individual records does *not* exhibit the >"next maximum" i.e. under normal circumstances the will keep >monotonically increasing.
Interesting - that's a fairly recent (last 12 months) change, then. Probably about the same time they came up with last_insert_id... Thanks. R