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
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 f
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