Delete tables starting with the same name in MySQL

Tiempo de lectura: < 1 minuto Reading time: < 1 minute If we want to delete different tables that start with the same name or name index, for example: videos_1 videos_2 videos_3 We can use this script: SELECT CONCAT(‘DROP TABLE ‘, table_name, ‘;’) statement FROM information_schema.tables WHERE table_name LIKE ‘videos_%’; This script will return the code that we need to execute: … Read more