Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CONCAT('RENAME TABLE ', GROUP_CONCAT('`', TABLE_SCHEMA, '`.`', TABLE_NAME, '` TO `', TABLE_SCHEMA, '`.`prefix_', TABLE_NAME, '`')) AS q
- FROM
- `information_schema`.`Tables` WHERE TABLE_SCHEMA='test';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement