This sql clause will generate drop clauses
SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;') FROM information_schema.tables WHERE table_schema = 'MyDatabaseName';
Get result and paste to command line
Post a Comment
No comments:
Post a Comment