For MySQL: ALTER TABLE tablename AUTO_INCREMENT = 1
-Jim On Sunday, April 27, 2014 6:59:28 AM UTC-5, Niphlod wrote: > > > > On Sunday, April 27, 2014 5:40:17 AM UTC+2, Massimo Di Pierro wrote: >> >> How about >> >> db.table.truncate() >> > > it will nuke every record in the table (plus any table that has a > reference to auth_user) but it won't reset the id > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.

