PROTECTED] wrote:
I use
mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' 1.txt
but it would be nice to see other solutions...
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2008 6:37 AM
To: mysql
Subject: spool log to a file
-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2008 6:37 AM
To: mysql
Subject: spool log to a file
Hi All,
I am executing below command, but there is no entires in 1.txt, its
an
empty file. How can i write the logs into this file.
mysql -uroot -pxxx
solutions...
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2008 6:37 AM
To: mysql
Subject: spool log to a file
Hi All,
I am executing below command, but there is no entires in 1.txt, its
an
empty file. How can i write the logs
Hi All,
I am executing below command, but there is no entires in 1.txt, its an
empty file. How can i write the logs into this file.
mysql -uroot -pxxx -Dtest -s --tee=1.txt -e 'select * from amc_25;'
regards
anandkl
Hi All,
I am executing below command, but there is no entires in 1.txt, its an
empty file. How can i write the logs into this file.
mysql -uroot -pxxx -Dtest -s --tee=1.txt -e 'select * from amc_25;'
regards
anandkl
I use
mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' 1.txt
but it would be nice to see other solutions...
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2008 6:37 AM
To: mysql
Subject: spool log to a file
Hi All,
I am executing
Hi All,
I am executing a script from mysql prompt as below
mysql source ddl.txt
I want to spool the out put of the above command to a file along with the
sql statments. Can you please let me know what parameter should i set for
the this.
regards
anandkl
PROTECTED] wrote:
Hi,
Ananda Kumar wrote:
Hi All,
I am executing a script from mysql prompt as below
mysql source ddl.txt
I want to spool the out put of the above command to a file along with
the
sql statments. Can you please let me know what parameter should i set
for
the this.
Use
(0.00 sec)
On 5/21/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Ananda Kumar wrote:
Hi All,
I am executing a script from mysql prompt as below
mysql source ddl.txt
I want to spool the out put of the above command to a file along with
the
sql statments. Can you please let me know
[EMAIL PROTECTED] wrote:
Hi,
Ananda Kumar wrote:
Hi All,
I am executing a script from mysql prompt as below
mysql source ddl.txt
I want to spool the out put of the above command to a file along with
the
sql statments. Can you please let me know what parameter should i set
|
+--+
1 row in set (0.00 sec)
On 5/21/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Ananda Kumar wrote:
Hi All,
I am executing a script from mysql prompt as below
mysql source ddl.txt
I want to spool the out put of the above command to a file along
with
the
sql
Kumar wrote:
Hi All,
I am executing a script from mysql prompt as below
mysql source ddl.txt
I want to spool the out put of the above command to a file along
with
the
sql statments. Can you please let me know what parameter should i
set
for
the this.
Use the 'tee
Hi Michale, all
[EMAIL PROTECTED] wrote:
most likely you just need to redirect STDERR to tee as well so it's not
a mysql problem:
mysql -u -p -f eof 21 | tee ttt.txt
...
assuming it's Bourne or ksh, don't remember what's csh for 21
It is an appended '': prog file
please help how can i spool all the output
into a file.
Below is the simple script i am using, ttt.txt is the file which will
contain the all the output of the script.
mysql -u -p -f eof | tee ttt.txt
use dev1;
select count(*) from rep_abc;
select count(*) from rep_fact;
exit
eof
: Thu, 26 Apr 2007 8:15 AM
Subject: spool data/log into a file.
Hi All,
I have written a script to connect to mysql and all the command results
is
spooled into a file.
But when an error occurs in mysql, it stops at that point and does not
proceed to the next command, also these error command
/godson/run.sh
also can finish what you want!
- Original Message -
From: g gnanaraj [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 9:50 PM
Subject: Re: table row result spool to file
Hi
Thanks but I'm not getting
Hi
I need to create a file from the row of a table. I have done the following but it
does not create a file but only display it on screen. What am I missing?
Thanks.
[EMAIL PROTECTED] godson]$ mysql -e select * from baa; --pager=t.sh test
Hi
Thanks but I'm not getting the expected result. See the following:
[quote]
[EMAIL PROTECTED] godson]$ cat chk5.sh
mysql -e select * from baa into outfile \/home/godson/run.sh\; test
[EMAIL PROTECTED] godson]$ ./chk5.sh
ERROR 1045 at line 1: Access denied for user: '@localhost' (Using
On Tuesday 25 February 2003 15:50, g gnanaraj wrote:
Thanks but I'm not getting the expected result. See the following:
[quote]
[EMAIL PROTECTED] godson]$ cat chk5.sh
mysql -e select * from baa into outfile \/home/godson/run.sh\; test
[EMAIL PROTECTED] godson]$ ./chk5.sh
ERROR 1045 at
Silmara,
Wednesday, November 13, 2002, 6:45:51 PM, you wrote:
S The MySQL have SPOOL where can I stores query results in a file?
S How can I do this?
Sorry, your question is not clear enough for me.
Take a look at SELECT .. INTO OUTFILE command
or may be --tee option of mysql command-line
The MySQL have SPOOL where can I stores query results in a file?
How can I do this?
How can I show my Indexes, Primary keys and Foreign Keys?
best regards,
Sil
-
Before posting, please check:
http://www.mysql.com/manual.php
to mysql. I know, in Oracle, when you spool file, then
spool off, this will create a file on your server. What is the
equivalent command for Mysql.
For example:
sqlplus Spool C:\temp\table_names
sqlplus select table_name from user_tables;
sqlplus spool off;
This will create a file on the server
* Cindy Yu, January 23, 2002 7:18 PM
When I use this on Sun saloris, it does work.
ok... I guess you mean solaris, and maybe you even mean it does NOT work?
mysql use mysql
Database changed
mysql tee /usr/local/var/ub_store
it shows syntax error with tee.
What do you mean it shows syntax
Hello,
I am new to mysql. I know, in Oracle, when you spool file, then spool off, this will
create a file on your server. What is the equivalent command for Mysql.
For example:
sqlplus Spool C:\temp\table_names
sqlplus select table_name from user_tables;
sqlplus spool off;
This will create
Check out select into outfile.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL
ECT
Ryan
- Original Message -
From: Cindy Yu [EMAIL PROTECTED]
I am new to mysql. I know, in Oracle, when you spool file, then spool off,
this will create a file on your server
* Cindy Yu
I am new to mysql. I know, in Oracle, when you spool file, then
spool off, this will create a file on your server. What is the
equivalent command for Mysql.
For example:
sqlplus Spool C:\temp\table_names
sqlplus select table_name from user_tables;
sqlplus spool off
Hi.
this is a minor problem that is driving me nuts.
I have a query that runs nicely and I want to save its timing information
in a spool file. When I connect to mysql and run the query it adds
the time elapsed after the data (9 rows in set 1.1 sec). But
when I run the same query in the line
Hi
this is a 2nd attempt. My first post never made it to the list.
What I'm trying to do is to spool queries results into a spool file
(via tee command). For some reason the timing information doesn't
get there. When I run a query from mysql, the output is followed by
a line with the number
28 matches
Mail list logo