1. Adding a prefix to all tables in a MySQL database SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_', TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema = 'my_database' 출처 : https://steindom.com/articles/adding-prefix-all-tables-mysql-database 2. SELECT GROUP_CONCAT('RENAME TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAM... 더보기