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
DROP TABLE tablename;
DELETE FROM `table_name` [WHERE condition];
DROP TABLE IF EXISTS table1;
delete table query
DROP TABLE <table name;
e.g. DROP TABLE students;