Is there any SQL query syntax that returns query execution time and query result at the same time?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as off topic by Derek Downey, Jack Douglas♦, jcolebrand♦ Aug 3 '11 at 14:21
Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.
I agree with @DTest, how are your running your query? If you log directly into a MySQL terminal style and hand-run queries, it will give you a time result. Also, if you use Oracles MySQL database tool (I believe it is called "MySQL Workbench"), you can connect to your database server directly and the GUI will also give you time results for the query if you hand-run it.