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? 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. 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
Archived
This topic is now archived and is closed to further replies.