LLLLLLL Posted May 6, 2013 Share Posted May 6, 2013 How can I declare the name of the output column with a "show tables" command? The default result is Tables_in_your_database_name How can I change it to be something else? "show tables as TBL" doesn't work. Is there something similar? Quote Link to comment https://forums.phpfreaks.com/topic/277729-show-tables-output-column-name/ Share on other sites More sharing options...
requinix Posted May 7, 2013 Share Posted May 7, 2013 Don't fetch associatively? Quote Link to comment https://forums.phpfreaks.com/topic/277729-show-tables-output-column-name/#findComment-1428723 Share on other sites More sharing options...
LLLLLLL Posted May 7, 2013 Author Share Posted May 7, 2013 Well yes, that works for the PHP side of things. I was just curious about the command itself, wondering if it's possible to get a different output. Quote Link to comment https://forums.phpfreaks.com/topic/277729-show-tables-output-column-name/#findComment-1428727 Share on other sites More sharing options...
Solution requinix Posted May 7, 2013 Solution Share Posted May 7, 2013 Nope. It's not supposed to be very flexible: just a list of tables (and maybe views). Quote Link to comment https://forums.phpfreaks.com/topic/277729-show-tables-output-column-name/#findComment-1428737 Share on other sites More sharing options...
LLLLLLL Posted May 7, 2013 Author Share Posted May 7, 2013 OK. I couldn't find anything else on that site either but I thought I'd ask. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/277729-show-tables-output-column-name/#findComment-1428739 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.