I'm trying to run a stored query with the results sent to an excel file. Each time I
try I get an Outfile Disabled message. Any suggestions? I'm running Winxp.
msql> source interests.sql c:\test.xls
= Outfile Disabled.
Thank you.
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
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
m
space between the key name and the key columns, but my
>personal
> > > > dumpfiles show that all non-primary keys have no space between the key
>name
> > > > and the key column names. Go figure. :) Needless to say I don't get
>it.
the source file mysqldump.c and it appears that there
>always
> > > should be a space between the key name and the key columns, but my
>personal
> > > dumpfiles show that all non-primary keys have no space between the key
>name
> > > and
> >
> >I looked through the source file mysqldump.c and it appears that there always
> >should be a space between the key name and the key columns, but my personal
> >dumpfiles show that all non-primary keys have no space between the key name
> > and the key column names. Go f
non-primary keys have no space between the key name
> and the key column names. Go figure. :) Needless to say I don't get it.
>
> >How-To-Repeat:
> See above description.
> >Fix:
> See above description.
>
> >Submitter-Id:
ace between the key name and the key columns, but my personal
dumpfiles show that all non-primary keys have no space between the key name
and the key column names. Go figure. :) Needless to say I don't get it.
>How-To-Repeat:
See above description.
>Fix:
10 matches
Mail list logo
