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
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
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, w
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" a
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 * fr
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 s
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
ier; [EMAIL 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: &q
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 (solaris 2.6)
> >
> >when I run this command :
> >mysql -h localhost -u root -p mysql < did.query &
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
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 ask
t;[EMAIL PROTECTED]>
Sent: Wednesday, 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 < di
Dnia Wed, 26 Mar 2003 12:12:44 +0100
"Marianadin, Didier" <[EMAIL PROTECTED]> zeznał/a co następuje:
> 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 l
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 li
whatever.
>> 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. C
>
Cc: <[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 th
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?
>
> I see that stored procedures are being added in a future release of
> MySQL, do I nee
e. 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?
I see that stored procedures are being added in a future release of MySQL,
do I need to wait for this?
Thanks in adv
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 o
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
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 .sq
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:
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...
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
sa
All,
Say I have a batch file I am attempting to run like this:
shell>mysql -h host_name -u username -p http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECT
--- 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 eff
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 eff
>
To: <[EMAIL PROTECTED]>
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 sp
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
30 matches
Mail list logo
