mysql delete table data code example

Example 1: drop table in mysql

DROP TABLE table_name;

Example 2: delete all content in table mysql

TRUNCATE tablename

Example 3: 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`;