Feature-request: Add sql-drop command

[mikran]

trafficstars

Drush for Drupal has this, and it is useful when restoring db dumps. Command: moosh sql-drop -y && moosh sql-cli < myBackup.sql

[tmuras]

As an alternative, I think we could use "moosh sql-run" and (at least in MySQL) - the DATABASE() function: https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_database

[mikran]

I'm not sure how that's an alternative. With sql-drop I'm looking to drop all tables from the database, not the whole database as that requires different kinds of permissions to do.

[tmuras]

I see. I usually prefer to DROP DATABASE and then CREATE DATABASE as that gives you 100% guarantee that everything was cleared (like functions, triggers). Maybe a better name (both here and in drush :) would be sql-drop-tables. Either way, it is a good idea - I'm marking that as a new feature and gladly accept a PR here!