Delete, Truncate or Drop MySQL question
- by Pete Herbert Penito
Hi Everyone!
I am attempting to clean out a table but not get rid of the actual structure of the table, i have the following columns: id, username, date, text
the id is auto incrementing, I don't need to keep the ID number, but i do need it to keep its auto-incrementing characteristic. I've found delete and truncate but I'm worried one of these will completely drop the entire table rendering future insert commands useless.
Thank you, Everybody!