javiertoledos of Creative Science Labs
5/17/2016 - 5:30 PM

MySQL Bulk rename (run as SQL the results of this query)

MySQL Bulk rename (run as SQL the results of this query)

bulk-prefix-removal.sql
content_copyfile_download
select concat('RENAME TABLE ', table_name, ' TO ', substr(table_name, 4), ';')
from information_schema.tables
where table_name like 'prefix%' and table_schema = 'dbname';