DROP TABLE from db mysql code example
Example 1: drop table in mysql
DROP TABLE table_name;
Example 2: mysql drop tables
mysql --silent --skip-column-names -e "SHOW TABLES" DB_NAME | xargs -L1 -I% echo 'DROP TABLE `%`;' | mysql -v DB_NAME
DROP TABLE table_name;
mysql --silent --skip-column-names -e "SHOW TABLES" DB_NAME | xargs -L1 -I% echo 'DROP TABLE `%`;' | mysql -v DB_NAME