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?
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?