lindm Posted July 27, 2008 Share Posted July 27, 2008 Why does SHOW COLUMNS FROM table LIKE 'cx%' work, but not SHOW COLUMNS FROM table,table2 LIKE 'cx%' ? Quote Link to comment https://forums.phpfreaks.com/topic/116861-show-columns-from-multiple-tables-not-possible/ Share on other sites More sharing options...
cooldude832 Posted July 27, 2008 Share Posted July 27, 2008 SHOW COLUMNS FROM table like 'cx%', table2 like 'cx%x' maybe??? Quote Link to comment https://forums.phpfreaks.com/topic/116861-show-columns-from-multiple-tables-not-possible/#findComment-600968 Share on other sites More sharing options...
lindm Posted July 27, 2008 Author Share Posted July 27, 2008 No luck on that one. Quote Link to comment https://forums.phpfreaks.com/topic/116861-show-columns-from-multiple-tables-not-possible/#findComment-600991 Share on other sites More sharing options...
fenway Posted July 28, 2008 Share Posted July 28, 2008 You can't do that... COLUMNS is for a given table only. Use the info_schema tables in MySQL 5 for anything else "fancy". Quote Link to comment https://forums.phpfreaks.com/topic/116861-show-columns-from-multiple-tables-not-possible/#findComment-601719 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.