Re: How to make individual batch SQL silent

[Paul DuBois]

At 6:58 -0500 10/11/02, rick  wrote:
>I know how to make a whole batch SQL script silent (-s option of 
>mysql), but is there a way within a script to make one or more 
>individual statements silent?  In Oracle PL/SQL, it can be done 
>using echo on/off and termout on/off.

Not really, though maybe this ugly hack will help:

mysql> \P >/dev/null
mysql> \n

The first sends query output to /dev/null, the second restores
normal output.