On Sat, Apr 26, 2003 at 10:01:32AM -0500, Raymond Norton wrote:
> I set up a database and did a bunch of testing. The id field is set to
> auto increment. I need to reset it, so it starts with id "1" . I tried
> to do it through phpMyAdmin, but I am not seeing how to do it. Any ideas
> how to do this? 
> 

If you delete all the entries from the table, your next insert
will start with id "1".

-- 
trammell at el-swifto.com  9EC7 BC6D E688 A184 9F58  FD4C 2C12 CC14 8ABA 36F5
Twin Cities Linux Users Group (TCLUG)      Minneapolis/St. Paul, Minnesota

_______________________________________________
TCLUG Mailing List - Minneapolis/St. Paul, Minnesota
http://www.mn-linux.org tclug-list at mn-linux.org
https://mailman.real-time.com/mailman/listinfo/tclug-list