how can i format a database's table in myPHPAdmin?

Status
Not open for further replies.

ewoogami

New Member
Messages
9
Reaction score
0
Points
1
as the title asks, how do i erase all the content from a table of a database in myPHPAdmin? i know i can just check all the boxes and delete, but what i want is to delete all content and to return the ID number to 0 so when i start adding again it will start at 1, cause when i delete contents from a table and then add it will just continue to increment the ID number to the next number after the deleted one.. if there is anyway to do this without deleting the table of course...

also when i go to the structure of my table i get this red mark on the overhead under space usage? should i click the optimize table? pic1.jpg
 

bdistler

Well-Known Member
Prime Account
Messages
3,534
Reaction score
196
Points
63
Set [ AUTO_INCREMENT ] = 0 - at [ Operations ]
 
Status
Not open for further replies.
Top