Mega Code Archive

 

Categories / MySQL Tutorial / Information Functions

 

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

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