[colug-432] Bash fun
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