Forum OpenACS Q&A: Re: How to flush MySql database table?????

Collapse
Posted by Rob Storrs on
To drop data without changing the table structure:
delete from [tablename]; (replace [tablename] with the name of your table)

That will delete all rows in the table without modifying the table structure. All of the data will be removed from the table. This is a pretty basic SQL function, you may want to review a SQL reference (like SQL for Web Nerds).