How to drop all tables named `type` from several hundred MySQL databases with the same prefix in one command?

Question

MySQL

DROP TABLE is apparently not for such operations?

Answer 1

uuu... one command is unlikely, but you can build the pipeline
for i in `mysql -e -pxxx -u user "show database prefix%"`; do mysql -e -pxxx -u user $i "drop table type"; done
something like this, implementation details are possible