Hello,
when I try
mysql select * from member;
it shows lots of records and the screen goes up quickly. Thus I can't see
the results very well because of the small screen (only 19 :):):) and I
wonder if there's a way to output the results into a .txt file.
why not be like:
mysql use samp_db
Yasen,
why not be like:
mysql use samp_db
mysql select * from member output_file.txt
Why not use:
mysql SELECT * FROM member INTO OUTFILE 'output_file_text';
?
Another way:
mysql SELECT * FROM member LIMIT 0,10;
And, to see the next 10 members:
mysql SELECT * FROM member LIMIT 10,10;
On Thursday 20 March 2003 16:14, Yasen Petrov wrote:
mysql select * from member;
it shows lots of records and the screen goes up quickly. Thus I can't see
the results very well because of the small screen (only 19 :):):) and I
wonder if there's a way to output the results into a .txt file.
At 15:14 +0100 3/20/03, Yasen Petrov wrote:
Hello,
when I try
mysql select * from member;
it shows lots of records and the screen goes up quickly. Thus I can't see
the results very well because of the small screen (only 19 :):):) and I
wonder if there's a way to output the results into a .txt