CREATE DATABASE IF NOT EXISTS #agency_db# SELECT table_name FROM information_schema.tables WHERE table_schema = 'agency_179' and table_name not like 'x%' SET innodb_strict_mode = 0; CREATE TABLE #agency_db#.#tablesname# LIKE agency_179.#tablesname#