[colug-432] Bash fun

[Tom Hanlon]

On 1 Nov 2009, at 14:05, R P Herrold wrote:

> On Sun, 1 Nov 2009, Tom Hanlon wrote:
>
>> Unfortunate but I do not know how to batch explain from inside mysql.
>
> sql does not have the concept of a 'sleep' type command, in the  
> SQL-92, ff, language specification; this falls to the feeding  
> process, about which more in a moment


Mysql actually has a perhaps non SQL standard, sleep function.

Select sleep(10) ;

Beware when used against a table, your results might not be as expected.

select sleep(10) from larg_table ;

will sleep 10 seconds for each row, and perhaps lock the table  
(myisam) while it sleeps.

--
Tom