Entry

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

Feb 12th, 2008 04:20
dman, ditoiu cristian, Jon Steppe, http://sturly.com

c1. server
c2. user(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';

http://www.mysql.com/doc/S/E/SELECT.html