Re: HOW TO : SQL Request in a file

2001-12-08 Thread 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

Re: HOW TO : SQL Request in a file

2001-12-08 Thread Richard R. Harms
Check out the 'INTO OUTFILE' portion of the 'SELECT' command: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT -rh >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