totallytech Posted March 17, 2013 Share Posted March 17, 2013 Hey Guys, I've got a database full of tables at the moment and I need to remove the first 2 characters from every single table. vbaccess = access vbaction = action etc etc its always removing "VB" from before the main table name I'm guessing its something like: RENAME TABLE `forum` . `access` TO `forum` . `vbaccess` ; But is there a way to do it en-mass, as there are currently 246 tables and dont fancy doing it manually. Any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/275761-simple-mysql-query-to-rename-table-names/ Share on other sites More sharing options...
jcbones Posted March 17, 2013 Share Posted March 17, 2013 You may be able to use SUBSTRING(), but I have never tried it in that context. Quote Link to comment https://forums.phpfreaks.com/topic/275761-simple-mysql-query-to-rename-table-names/#findComment-1419116 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.