CODE EXAMPLE FOR SQL

mysql delete data in table

TRUNCATE tablename; //offers better performance, but used only when all entries need to be cleared
or
DELETE FROM tablename; //returns the number of rows deleted