dtateii/tables_prefixer.sql

Created August 25, 2016 01:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dtateii/08ff37f9087171316c933fd20b91ea59.js"></script>
Save dtateii/08ff37f9087171316c933fd20b91ea59 to your computer and use it in GitHub Desktop.

Download ZIP

Prefix All Database Tables

Raw

tables_prefixer.sql

SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_', TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema = 'my_database_name'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment