Page 1 of 1

reset primary key im MySQL

Posted: Thu Dec 03, 2009 8:52 am
by nevx009
can the primary key be reset to 1 in MYSQL ?

Re: reset primary key im MySQL

Posted: Thu Dec 03, 2009 8:55 am
by ianhull
Yes, but you will lose your records.

TRUNCATE TABLE `tablename`