empty a table - MySQL50
Posted on 2006-07-02
using MySQL 5.0 - - >
what is the easiest way to empty a table? iow ~ to delete all the data that the table contains... i'm not talking about dropping the table completely... rather, just to empty (clear) all the data from it.
is there a way to to this with a "right"-click on the tablename after right-clicking and going to "Edit Table Data" ? if not, what is the SQL statement because DELETE * FROM 'database'.'tablename' doesn't seem to really empty the table.. cause when i go back to the MySQL Administrator and hit Refresh.. the data in the table still exists. ??