how to delete mysql table code example

Example 1: clear a table in mysql

truncate tableName

Example 2: drop table in mysql

DROP TABLE table_name;

Example 3: how to delete a table entry in mysql

DELETE FROM `table_name` [WHERE condition];

Example 4: how to DROP a table in mysql

-- 'DROP TABLE' followed by the name of the table you would like
-- to drop.
DROP TABLE `test_table`;

Example 5: delete table in mysql

delete table query

DROP TABLE <table name;
e.g. DROP TABLE students;