SQL

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`;

how to delete a table in mysql

DROP TABLE tablename;

delete table in mysql

delete table query

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

How to drop table in mysql ?

DROP TABLE countries;
Code language: SQL (Structured Query Language) (sql)

mysql drop tables

mysql --silent --skip-column-names -e "SHOW TABLES" DB_NAME | xargs -L1 -I% echo 'DROP TABLE `%`;' | mysql -v DB_NAME

mysql drop table

DROP TABLE table;
DROP TABLE IF EXISTS table;
DROP TABLE table1, table2, ...