[2hands]

Hi,
We are getting ready to open our Christmas help section and want to delete all 18,000 comments from the previous year in the Christmas table in myPhp. I am needing direction on the proper way to do this. Is it the truncate or drop command? I do not want to damage the table so would appreciate input.
Thank you!

Jon

[2hands]

Hi,
We are getting ready to open our Christmas help section and want to delete all 18,000 comments from the previous year in the Christmas table in myPhp. I am needing direction on the proper way to do this. Is it the truncate or drop command? I do not want to damage the table so would appreciate input.
Thank you!

Jon

To correct my above question, I am using phpMyAdmin, not myphp. Thanks again for any input.

[Steven]

Hi Jon,

It's the truncate command. This will delete all of the data in the table.

The drop command would delete the table itself so don't do that.

After truncating the 'comments' table, also truncate the 'reporters' and 'voters' tables.

[Steven]

Make a backup of the database first just to be safe.