On Tue, May 1, 2007 22:15, Brown, Charles wrote:
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me no output but this input
show tables gave me an output
On Wed, May 2, 2007 08:55, Mogens Melander wrote:
On Tue, May 1, 2007 22:15, Brown, Charles wrote:
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me no output but this input
show tables gave me an output.
What is missing, what's the trick. Help me Y'all.
Thx
I am trying to right sql statement on the shell prompt but its not going
through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security select * from machine;
-bash: select: No such file or directory
It is asking for the text file. And it works fine with the text file. I am
wondering
azamka wrote:
I am trying to right sql statement on the shell prompt but its not going
through.
Here is the statement:
[EMAIL PROTECTED] usr]# mysql security select * from machine;
-bash: select: No such file or directory
echo select * from machine | mysql security
or put your select
On Tue, 2003-07-29 at 15:19, azamka wrote:
[EMAIL PROTECTED] usr]# mysql security select * from machine;
-bash: select: No such file or directory
EEK! What you told the shell to do was open a file called select and
redirect it to mysql.
What you meant to do was echo 'select * from
In the last episode (Jul 29), Peter L. Berghold said:
On Tue, 2003-07-29 at 15:19, azamka wrote:
[EMAIL PROTECTED] usr]# mysql security select * from machine;
-bash: select: No such file or directory
EEK! What you told the shell to do was open a file called select and
redirect
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql did.query did.out
I'm always asked password even if I've already specified it in the previous
command line (mysql)
Enter
Dnia Wed, 26 Mar 2003 12:12:44 +0100
Marianadin, Didier [EMAIL PROTECTED] zezna/a co nastpuje:
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql did.query did.out
I'm
, March 26, 2003 13:12
Subject: mysql under unix in batch mode
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql did.query did.out
I'm always asked password even if I've already
On Wednesday 26 March 2003 13:12, Marianadin Didier wrote:
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql did.query did.out
I'm always asked password even if I've already
Create a .my.cnf file in your home directory with permissions set to 600.
In that file put the lines
[mysql]
user=root
password=mysql
now you can enter:
mysql did.query did.out
Marianadin, Didier wrote:
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix
to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql did.query did.out
I'm always asked password even if I've already specified it in the
previous command line (mysql)
Enter password:
How
PROTECTED]
Subject: Re: mysql under unix in batch mode
Hi,
most probably there should not be a space after -p.
Try this
mysql -h localhost -uroot -pmysql did.query did.out
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: Marianadin, Didier [EMAIL
PROTECTED]
Sent: Friday, February 07, 2003 5:27 PM
Subject: Re: Batch mode / stored prodecure question?
Hmm, I thought this question I posted last weekend was a pretty
good one, however, no replies have been posted :-(
I am new to MySQL and this mailing list, is the the proper place
.
The RADIUS server can call a stored procedure and pass parameters to
the procedure. This is what I need. I see that MySQL has a batch
mode, but I do not see any mention of how I could pass parameters to a
MySQL batch file. Can I do this, if so, how?
MySQL's batch mode is actually the MySQL Monitor's
. This is fine for creating a usage
record, but I need to do more processing and execute several SQL
statements in order to do all the usage tracking I need.
The RADIUS server can call a stored procedure and pass parameters to
the procedure. This is what I need. I see that MySQL has a batch
mode
I need. I see that MySQL has a batch mode, but I
do not see any mention of how I could pass parameters to a MySQL batch
file. Can I do this, if so, how?
I see that stored procedures are being added in a future release of MySQL,
do I need to wait for this?
Thanks in advance,
Bill Brownrigg
Project
Hi all:
I am running MySQL 4.0.9 on Red Hat 7.2
Also using MyODBC to connect to a Win 2K system running a RADIUS server
(Steel Belted Radius)
I have a MySQL database that tracks usage information coming from the
RADIUS server. Everything is working, but the problem is that the RADIUS
server can
Has anyone else experienced this problem? To me, it looks like a bug since
according to the MySQL manual, the batch mode should work just as if the
statements where entered directly from the mysql prompt, but it appears not
to be true.
-Joacim
-Original Message-
From: Joacim Larsson
I am using MySQL 3.23.53 with InnoDB tables on Win2K platform.
My charset is set to latin1 and it works fine when I use Swedish characters
through JDBC. It also works fine if I use them from the mysql command line,
but when I try to use mysql file.sql to load a set of INSERTs into my
tables
I get
Hello mySQL users,
I'm a new mySQL user, just installed it two days ago.
I have a quick question... I have a .sql script that I want to run on
mySQL server. I have a Windows XP machine and when I read the mySQL manual,
I think they were talking about a Unix machine. This is what the manual
Hello,
In the directory you have your .sql script, run this:
mysql myquery.sql
Remember to change the file name, though. :-)
Regards,
Iikka
On Thu, 5 Sep 2002, Horacio Santoyo wrote:
Hello mySQL users,
I'm a new mySQL user, just installed it two days ago.
I have a quick question... I
When I saw this mail arrive I thought the subject read Using mySQL in
Biatch mode, I did chuckle a little :)
-Original Message-
From: Horacio Santoyo [mailto:[EMAIL PROTECTED]]
Sent: 05 September 2002 21:13
To: [EMAIL PROTECTED]
Subject: Using mySQL in Batch mode
Hello mySQL
You have to do in your command shell, not mysql shell...
Go to run , type cmd
and then type mysql batch-file ..
Gurhan
On Thu, 2002-09-05 at 16:12, Horacio Santoyo wrote:
Hello mySQL users,
I'm a new mySQL user, just installed it two days ago.
I have a quick question... I have a .sql
All,
Say I have a batch file I am attempting to run like this:
shellmysql -h host_name -u username -p batch_file
Further, say this batch_file has multiple WHERE lines as follows:
use dB1
SELECT x,y,z,zXXName, zYYName, zZZName FROM tblXXX WHERE
zXXName = run0 AND zYYName = farther0 AND zZZName
Hi all!
I've got trouble when i need to run mysql with batch mode. I can't run it.
I did these following steps
shell mysql -u root -p --batch
password : **
-
then the screen had no effect.
I do this step too
shell mysql -u root -p -B
password : **
-
this had no effect too.
Please
--- Feny Suha [EMAIL PROTECTED] wrote:
Hi all!
I've got trouble when i need to run mysql with batch mode. I can't run it.
I did these following steps
shell mysql -u root -p --batch
password : **
-
then the screen had no effect.
I do this step too
shell mysql -u root -p -B
i'm trying to execute a sql script in batch mode. the command i'm typing is:
mysql createdb.sql;
does the createdb.sql script need to be in a specific directory for mysql to
recognize it? i've tried putting it in mysql\bin and mysql and specifying
relative and absolute paths to the file
CTED]
Sent: Saturday, March 10, 2001 3:09 PM
Subject: executing scripts in batch mode
i'm trying to execute a sql script in batch mode. the command i'm typing
is:
mysql createdb.sql;
does the createdb.sql script need to be in a specific directory for mysql
to
recognize it? i've tri
30 matches
Mail list logo