thiggins09 Posted August 27, 2009 Share Posted August 27, 2009 Is there a way to extract a queries table, limit , and order by information? For example: SELECT * FROM `table` ORDER BY `a` LIMIT 1,2 Can I somehow ask MySQL what the limit was, if there was one, and how this SELECT is being ordered. I am aware EXPLAIN can return the table, but as for obtaining the other information I am lost. Thank you Link to comment https://forums.phpfreaks.com/topic/172202-explaining-a-query/ Share on other sites More sharing options...
corbin Posted August 27, 2009 Share Posted August 27, 2009 Errrr.... You could parse the query your self, but as far as I know, MySQL does not do that. Link to comment https://forums.phpfreaks.com/topic/172202-explaining-a-query/#findComment-907964 Share on other sites More sharing options...
thiggins09 Posted August 27, 2009 Author Share Posted August 27, 2009 Hhh I feared it would come to that. Thank you. Link to comment https://forums.phpfreaks.com/topic/172202-explaining-a-query/#findComment-907970 Share on other sites More sharing options...
roopurt18 Posted August 28, 2009 Share Posted August 28, 2009 http://dev.mysql.com/doc/refman/5.0/en/select.html [sql_CALC_FOUND_ROWS] It's being ordered by `a`. Link to comment https://forums.phpfreaks.com/topic/172202-explaining-a-query/#findComment-908143 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.