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-t 더보기