Re: Redirect output to the file

Jerry Swanson wrote: I want to redirect output of the query to the file in tab delimited format. Can this be done? Thanks Select ... INTO OUTFILE: http://dev.mysql.com/doc/mysql/en/SELECT.html or mysql -e (documentation on the same page) HTH, Wolfram -- MySQL General Mailing List For list

RE: redirect output to a file?

Yes you can run querys from the mysql prompt and redirct them to a file. Here's how. Make a file and call it query. Inside the file put something like this: use db_mydatabase select * from tbl_mytable where something=somethingelse; Then from the prompt (not in the mysql prompt) use this