[colug-432] Bash fun

Tom Hanlon tom at functionalmedia.com
Tue Nov 3 09:17:01 EST 2009

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.


More information about the colug-432 mailing list