Re: HOW TO : SQL Request in a file

[Paul DuBois]

At 7:39 PM +0100 12/8/01, Fred Taurus wrote:
>Hello
>
>Is it possible to put the result of a Mysql request in a file
>
>and how to do this ?
>
>I try
>
>mysql >SELECT name from table where name like 'B%'; > file.txt
>
>but error !
>
>Thanks for your help
>
>Frederic

mysql> \T query.out
Logging to file 'query.out'

The command line option for \T is mysql --tee=query.out
This was added as of 3.23.28, I think.