mysql drop tables code example

Example 1: mysql drop

DROP TABLE table_name

Example 2: drop table in mysql

DROP TABLE table_name;

Example 3: to delete a table in mysl

drop table table_name;

Example 4: delete table in mysql

delete table query

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

Example 5: mysql drop tables

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