Is there any SQL query syntax that returns query execution time and query result at the same time?

  • 3
    From what context? A normal select returns this information: mysql> SELECT 1; +---+ | 1 | +---+ | 1 | +---+ 1 row in set (0.04 sec) Commented Jul 26, 2011 at 15:49
  • There really isn't a redeeming quality to this question. It's not being updated/followed up on, and it's not well formed. I'm closing (it may be reopened if edited to be of quality. If so, flag and we'll consider it).
    – jcolebrand
    Commented Aug 3, 2011 at 14:21

1 Answer 1


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.

  • I want to run it through my application and display execution time on application Windows.
    – RPK
    Commented Jul 27, 2011 at 4:38
  • @RPK since this is a question on a specific application, or programming language, you might re-ask it on stackoverflow with more details of what language you are using. Commented Jul 27, 2011 at 15:59

Not the answer you're looking for? Browse other questions tagged or ask your own question.