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