What would be the corresponding SQL for:
DROP TABLES LIKE 'test_%';
I just want to delete all the tables that have ‘test_’ as a prefix.
The current one does not work. It is a sample only to let you know what I wanted.
What would be the corresponding SQL for:
DROP TABLES LIKE 'test_%';
I just want to delete all the tables that have ‘test_’ as a prefix.
The current one does not work. It is a sample only to let you know what I wanted.
run this –
SELECT CONCAT('DROP TABLE ',table_name,';')
FROM information_schema.tables
WHERE table_name LIKE 'm%'
copy/paste the output and run that