29
1
Usually I open Terminal.app and connect to a remote MySQL database.
Then I use this command to drop a table:
mysql> drop table [table name];
But what I need is the command line to drop all tables in the database.
If I use:
mysql> drop database [database name];
I'll destroy the database completely and I won't be able to create tables again. Am I right?
MySQL Empty Database / Delete or Drop All Tables, MySQL - Drop all Tables in a Database Using a Single Command Line Command, Drop all tables from a MySQL Database without deletion, ... – slhck – 2011-07-08T11:44:01.627