MySQL Tutorial/Information Functions/BENCHMARK

BENCHMARK(count,expr) executes the expression expr repeatedly count times. :

   <source lang="sql">

mysql> mysql> mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye")); +----------------------------------------------+ | BENCHMARK(1000000,ENCODE("hello","goodbye")) | +----------------------------------------------+ | 0 | +----------------------------------------------+ 1 row in set (0.47 sec) mysql></source>