wipe out a table

Hi,

is there a command for mysql just to wipe out all the data from a table, i dont want to delete the table! I just need to restart the table without setting up the fields and stuff again

delete from tablename;

since no where clause is included it deletes all records

HTH

Rod

Note also that when you use the syntax:

delete from tableName;

It will reply that zero rows were affected....MySQL just says that to improve performance. If you want to see exactly how many records were deleted use this query:

delete from tableName where 1=1;