FAQTs - Knowledge Base - View Entry - How can I direct the results of a query to a user's computer not the server (outfile)?

Home My Faqts Contributors About Help Link to FAQTS

faqts : Computers : Databases : MySQL

Entry

Add Entry Alert - Edit this Entry

Did You Find This Entry Useful?

9 of 11 people (82%) answered Yes
Recently 7 of 9 people (78%) answered Yes

How can I direct the results of a query to a user's computer not the server (outfile)?

Jan 9th, 2002 02:38

ditoiu cristian, Jon Steppe
http://www.mysql.com/doc/S/E/SELECT.html

c1. server
c2. uzer(computer) . 
c2 connects to c1 via mysql -h c1 -u uzer -p database
Then on c2 you can select filed1,filed2 from table1 into 
outfile 'outfile.txt';