Is there any way I can change the name of a table. At the moment I have tables like;
links_something
links_category
links_rubbish
Is there any way, or script, that you could rename the tables to have capitals in the second palf of it (i.e after the _). Like this;
links_Something
links_Category
links_Rubbish
I'm assuming it could be done by grabbing the list of tables in the database, and then splitting thgem up by the _. Then capitalising the second half. However, I'm not very good with Perl and SQL...so any help you an offer would be appreciated
Thanks
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
links_something
links_category
links_rubbish
Is there any way, or script, that you could rename the tables to have capitals in the second palf of it (i.e after the _). Like this;
links_Something
links_Category
links_Rubbish
I'm assuming it could be done by grabbing the list of tables in the database, and then splitting thgem up by the _. Then capitalising the second half. However, I'm not very good with Perl and SQL...so any help you an offer would be appreciated
Thanks
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!