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 Quote 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. Quote 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. Quote 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`. Quote Link to comment https://forums.phpfreaks.com/topic/172202-explaining-a-query/#findComment-908143 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.