kingb00zer Posted April 26, 2011 Share Posted April 26, 2011 hey guys im curently writing some code that requires a variable $count to match id numbers which I have set in my tables as auto increment. the problem is that snce testing out many diferent things and deleting accounts i now how have the problem being that each sign up counts the increment to 26 when in total there is only 7 accounts. i want to delete all of these accounts which i made for testing and have all the auto incrememnting start again from 1 again. how would I do that without recreating each individual table? Link to comment Share on other sites More sharing options...
Synook Posted April 26, 2011 Share Posted April 26, 2011 TRUNCATE TABLE <tablename> Link to comment Share on other sites More sharing options...
kingb00zer Posted May 2, 2011 Author Share Posted May 2, 2011 thank you synook that worked a treat Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.