MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: BASH COMMAND TO SEARCH AND DELETE ALL EMPTY TABLES IN A DATABASE
Posted by: Rick James
Date: November 29, 2015 12:28PM

See if this gives you the correct list:

mysql -e "SELECT CONCAT('DROP TABLE ', table_schema, '.', table_name) FROM information_schema.tables WHERE table_schema NOT IN ('mysql', 'information_schema', 'performance_schema') AND table_rows = 0"

If it does, then redirect that to a file and send that to mysql.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
BASH COMMAND TO SEARCH AND DELETE ALL EMPTY TABLES IN A DATABASE
Eric Jason Notts
November 27, 2015 10:59AM
Re: BASH COMMAND TO SEARCH AND DELETE ALL EMPTY TABLES IN A DATABASE
Rick James
November 29, 2015 12:28PM
Re: BASH COMMAND TO SEARCH AND DELETE ALL EMPTY TABLES IN A DATABASE
Phillip Ward
November 30, 2015 06:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.