Re: How to get the used time when operate a select query?

$B2+=ULP wrote:
> How can I  get the time which a select query use?
> thank you!
>
>

If you are using version 7.2 or later, try the command

EXPLAIN ANALYZE <any query>

This will perform the query (even if it is a DELETE FROM <table>!)
and show the actual time.

/Oskar

Ps. You should check what your mail client puts in the from field
of you mail. It is quite unreadable...

--
/----------------------------------------------------------------------\
| Oskar Berggren        beo@sgs.o.se                                   |
| Network and Software Engineer                     SGS Datanätgrupp   |
|                                                   Gothenburg, Sweden |
\----------------------------------------------------------------------/