Dear MySQL users,
MySQL Shell 8.0.15 is a maintenance release of MySQL Shell 8.0 Series
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.
MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0
and 5.7. Please upgrade to MySQL Shell 8.0.15
Dear MySQL users,
MySQL Shell 8.0.14 is a maintenance release of MySQL Shell 8.0 Series
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.
MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0
and 5.7. Please upgrade to MySQL Shell 8.0.14
Dear MySQL users,
MySQL Shell 8.0.12 is a maintenance release of MySQL Shell 8.0 Series
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.
MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7.
Please upgrade to MySQL Shell 8.0.12
Dear MySQL users,
This is the second development release version of MySQL Shell 8.0
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.
MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration
Dear MySQL Users,
A new GA (general availability) version of MySQL Shell
(a component of the MySQL Server) has been made
available: MySQL Shell 1.0.10 GA. The MySQL Shell is provided
under Oracle's dual-license.
MySQL Shell is an interactive JavaScript, Python and SQL console
interface
Dear MySQL users,
This is the first development release version of MySQL Shell 8.0
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.
MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration
Dear MySQL Users,
This is the first GA version of MySQL Shell (a component of the MySQL
Server). The MySQL Shell is provided under Oracle's dual-license.
MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server
Dear MySQL users,
MySQL Shell 1.0.8 RC is the first release candidate of the MySQL
for MySQL Shell 1.0 series.
The MySQL Shell is an interactive JavaScript, Python and SQL
command-line interface, supporting development and administration for
the MySQL Server. The MySQL Shell includes the X
Dear MySQL users,
Today we are excited to announce for the first time the MySQL Shell, a
new component for the MySQL Server.
The MySQL Shell is an interactive JavaScript and Python command-line
interface, supporting development and administration for the MySQL
Server. The MySQL Shell enables
Not sure about the size of your dump, but, have you tried to set the new
value on the server and client side? you can increase max_allowed_packet up
to 1G. Let us know after you tried that, and maybe other guys have another
solution to share...
--
*Wagner Bianchi, +55.31.8654.9510*
Oracle ACE
Hi,
When we are trying to restore the dump file, we got an error like Got a
packet bigger than max_allowed_packet. Then we increased max_allowed_packet
variable size and passed along with MySQL restore command.
mysql -max_allowed_packet=128M -uusername -p /path/file.sql
After increasing the
Hi guys,
i have a problem when trying to pass shell variable to the SET data
type in parentheses.
i have a variable like this:
$ echo $var
value1,value2,value3
what i did:
mysql -u $user -p${password} --skip-column-names -e 'ALTER TABLE
'$table' MODIFY '$kolom' SET( '$var' );' $database
, Oct 3, 2012 at 9:35 AM, Morning Star
morning.star.c...@gmail.com wrote:
Hi guys,
i have a problem when trying to pass shell variable to the SET data
type in parentheses.
i have a variable like this:
$ echo $var
value1,value2,value3
what i did:
mysql -u $user -p${password} --skip-column
are you trying to get the value of var encapsulated with ' ' marks?
Typical shell expansion while within will output the literal:
var=10
echo '$var'
'10'
Have you tried removing the single quotes? The shell can be funny with ' and
garotconk...@yahoo.com
Star
morning.star.c...@gmail.com
Cc: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Wednesday, October 3, 2012 3:50 PM
Subject: Re: passing shell variable to the SET data type in parentheses
are you trying to get the value of var encapsulated with ' ' marks?
Typical shell expansion while
2012/10/03 20:35 +0700, Morning Star
$ echo $var
value1,value2,value3
what i did:
mysql -u $user -p${password} --skip-column-names -e 'ALTER TABLE
'$table' MODIFY '$kolom' SET( '$var' );' $database ;
the result:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;
check the
Thanks guys for all the corrections.
I fix it by executing:
mysql -u $user -p${password} --skip-column-names -e 'ALTER TABLE
'$table' MODIFY '$kolom' SET( '$var' );' $database ;
:)
Greetings,
Marco
On Thu, Oct 4, 2012 at 4:49 AM, h...@tbbs.net wrote:
2012/10/03 20:35 +0700, Morning Star
$
Here’s an email from a good friend of mine that may be of interest. It is done
in Ruby.
From: Brad Robel-Forrest [mailto:b...@gigglewax.com]
Sent: Sunday, May 15, 2011 7:01 PM
To: Daevid Vincent
Subject: MySQL shell...with parameters
Remember a long while back I was bitching about the need
http://www.daevid.com/content/examples/snippets.php
scroll down to Automatic Monitoring of remote servers
You'll need Gnome, ssh keys (for remote execution), .mytop file, wmctrl and
xtrlock.
I'm still using win2k mysql 5.1
With default databas encoding, I can do querys with bh English and Chinese GB.
But when database encoding is uft8, all the Chinese become question maks.
Any idea about how to mysql work unicode databa? Thanks a lot.
Pam Astor wrote:
The ANSI-SQL syntax is to just use GRANT to create users. You will
still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
But I find the MySql syntax for creating user with CREATE USER and then
GRANT easier to follow:
CREATE USER joe@'%' IDENTIFIED BY
The ANSI-SQL syntax is to just use GRANT to create users. You will
still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
But I find the MySql syntax for creating user with CREATE USER and then
GRANT easier to follow:
CREATE USER joe@'%' IDENTIFIED BY
in to MySQL via shell using the
username and password associated with that user. However for all the other
databases, I am not
able to log in to a MySQL shell using the other usernames associated with their
databases – even though the php applications are configured to use the
usernames, passwords
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
I ran “SELECT * from mysql.user;” the command
Pam Astor schrieb:
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
[...]
The seventh line shows
Pam Astor wrote:
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
I ran “SELECT * from mysql.user
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
would be much more easier if you would send this output here (with faked
names, passwords and hosts ...)
OK...here it is:
SELECT * from
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does this
Pam Astor wrote:
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
The ANSI-SQL syntax is to just use GRANT to create users. You will
still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
But I find the MySql syntax for creating user with CREATE USER and then
GRANT easier to follow:
CREATE USER joe@'%' IDENTIFIED BY
One more thing, I have already created these users and don't want to mess
their
passwords up or break their associated php scripts access.
So how do I grant users, who already have a password, localhost
access?
just copy the row in the mysql table
--
Sebastian Mendel
Not sure
in to MySQL via shell using the
username and password associated with that user. However for all the other
databases, I am not
able to log in to a MySQL shell using the other usernames associated with their
databases – even though the php applications are configured to use the
usernames, passwords
hello,
When saying 'exit' in mysql shell,mysqld would release the lock which was made
before.
But if I do 'ctrl+z' under linux to hang up mysql shell,would mysqld also
release the lock or not?
Thank you.
Viel oder wenig? Schnell oder langsam? Unbegrenzt surfen + telefonieren
ohne Zeit- und
type 'fg' it will move back to the foreground. CTRL-D is
typically the exit shortcut.
On 7/16/07, Jeff Pang [EMAIL PROTECTED] wrote:
hello,
When saying 'exit' in mysql shell,mysqld would release the lock which was made
before.
But if I do 'ctrl+z' under linux to hang up mysql shell,would mysqld
Now that all of the latest distros of OSX use bash by default, I thought I
would amend this with bash instructions.
When you instantiate a shell in OSX, the ~/.bash_login file is parsed.
Because this isn't a global file you can edit it just like the .tshrc below.
The entry you need to make
.:${PATH}:$HOME/bin:/usr/local/mysql/bin
To insert in vi press i. When you are done inserting press ESC.
To delete a character enter x.
To quit and save, enter :x.
To abort changes, enter :q!.
On Sep 8, 2006, at 8:54 PM, Pastor Steve wrote:
Greetings,
Does anyone know how I can set up my shell so
Greetings,
Does anyone know how I can set up my shell so that the mysql command works
without navigating to the directory? I am using Mac OS 10.2.8 and 10.4
shell mysql u name p
??
Thanks,
--
Steve Marquez
variables like '%char%';
show character set;
Kirill Sapelkin wrote:
Hello,
The mysql 4.1.16 shell does not accept alternate character set (koi8r -
russian) keyboard input. It accepts koi8r input fine in non interactive
mode as:
mysql our_database our_command.sql
Hello,
The mysql 4.1.16 shell does not accept alternate character set (koi8r -
russian) keyboard input. It accepts koi8r input fine in non interactive
mode as:
mysql our_database our_command.sql
and it displays both english and koi8r fine on screen.
It was comiled: configure
Hello Gleb!
The answer to the scrambled characters in the shell und XP is, as you
assumed, that the shell simply does not handle characters like the
Windows-GUI does... .
Now, that I know about this fact it's no longer a problem ( perhaps a
feature, ;-) ?).
Thx again have a good time,
Goetz
Hello Gleb,
thanks very much for the hints! I will read them and then give a
feedback to the list.
Have a nice day,Götz
--
--
! Diese E-Mail hat 0 Anhänge
-ABSENDER-
name Goetz M. Ritter
country Germany
e-mail [EMAIL PROTECTED]
Hello there,
I'm new to MySQL and have just installed the 5.0 on a WinXP-Workstation.
I have a question concerning the use of the shell-interface of my
mysql-Installation.
To load data in a table
I used WinXP-Notepad to create tab-separated records (they contain
special german chars
the use of the shell-interface of my
mysql-Installation.
To load data in a table
I used WinXP-Notepad to create tab-separated records (they contain
special german chars (Umlaute)
I used the LOAD DATA LOCAL INFILE-Statement to import the data.
Everything seems to be OK
-n hi)
regards,
esv
--- Rakesh Gupta [EMAIL PROTECTED] wrote:
Hi There,
I am trying to insert blob in table and then
retrieve it from table using
Linux shell. Here is script that i used.
Load Blob into DB and Retrieve it using linux shell.
# add firmware into DB
ACTION=insert
Hello.
Maybe mysql puts the name of the column (firmwareimage),
at the beginning of the output (--skip-column-names should prevent it).
Rakesh Gupta [EMAIL PROTECTED] wrote:
Hi There,
I am trying to insert blob in table and then retrieve it from table using
Linux shell
Hi There,
I am trying to insert blob in table and then retrieve it from table using
Linux shell. Here is script that i used.
Load Blob into DB and Retrieve it using linux shell.
# add firmware into DB
ACTION=insert into FIRMWARE
(firmwarename, releasedate, bootcodename, usermanualname
I am executing a mysql query through shell and expecting to see a return of SQL
execution.
mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile
rc=$?
Here rc is always 0 and so are $opFile entries. $queryFile contains exactly the
same query as listed below.
If the same
On Wed, 23 Feb 2005, Nupur Jain wrote:
Hi Nupur,
I am executing a mysql query through shell and expecting to see a return of SQL
execution.
mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile
rc=$?
Here rc is always 0 and so are $opFile entries. $queryFile contains exactly
On Wednesday, February 23, 2005 12:30, Nupur Jain wrote:
I am executing a mysql query through shell and expecting to see a
return of SQL execution.
mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile
$opFile
rc=$?
Here rc is always 0 and so are $opFile entries. $queryFile
At 10:29 -0800 2/23/05, Nupur Jain wrote:
I am executing a mysql query through shell and expecting to see a
return of SQL execution.
mysql -D $dbName --vertical -u $DBUSER -p$DBPASS $queryFile $opFile
rc=$?
Here rc is always 0 and so are $opFile entries. $queryFile contains
exactly the same
Wow - cool idea - nice job. Looking forward to playing with it.
David.
Eddy Macnaghten wrote:
Hi all
I have just released a utility (under the GPL) that enables SQL to be
incorporated into UNIX/LINUX shell scripts (easier than using psql or
similar with better integration).
For more information
Hi all
I have just released a utility (under the GPL) that enables SQL to be
incorporated into UNIX/LINUX shell scripts (easier than using psql or
similar with better integration).
For more information see http://www.edlsystems.com/shsql
To download ftp://ftp.edlsystems.com/shsql
(needless
I am struggling to get the bash script to use the password. What I'm
doing here is to assign it to a variable..
--snip-
MySQLdump_FilePath=/usr/local/mysql/bin/mysqldump
UserId=root
DB_Production=DB_NAME
#Emarket_Production_Filepath=`/home/website/ProductionDB.sql`
PROTECTED]
Subject: Bash Shell issue with the mysqldump's password.
I am struggling to get the bash script to use the password. What I'm doing
here is to assign it to a variable..
--snip-
MySQLdump_FilePath=/usr/local/mysql/bin/mysqldump
UserId=root
DB_Production=DB_NAME
Hello Serge,
Serge E. Yakubovich wrote:
Description:
First of all I want to thank you for your excelent bug report and apologize for
delayed responce.
The same test script I've submitted today to [EMAIL PROTECTED],
which demonstrates improper(?) behaviour of UPDATE statement on
4.0.12
. My thoughts were to write a shell script
to do this for me, but I am running into a problem: I wrote the following:
#!/bin/sh
date=`date +%m%d%Y`
export date
mysql -u root -p createdb.sql
Then in createdb.sql
CONNECT Blah;
CREATE TABLE $date (
.
) TYPE=MyISAM;
But it's not passing the $date
Wouldn't this also work?:
mysql -u root -p -e CREATE TABLE t$date(...) yourdatabase
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mysql List
Subject: RE: DB design question - shell scripting
: DB design question - shell scripting...
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a problem: I wrote
Andy,
Thanks for responding. I think that I am going to go with the idea of
creating a tale for each day. My thoughts were to write a shell script to
do this for me, but I am running into a problem: I wrote the following:
#!/bin/sh
date=`date +%m%d%Y`
export date
mysql -u root -p
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a problem: I wrote
the following:
#!/bin/sh
date=`date +%m
it to the hard drive,
here's what i've tried so far,
I create a text file called test1:
use my_db;
select * into dumpfile /usr/local/test1 from my_table;
so when i try shell mysql --pager test1 | tar x
the tar file does get written to /usr/local/test1 which is the step
At 11:03 -0500 11/19/03, Denis Mercier wrote:
i also tried:
use my_db;
select * from my_table;
so when i try shell mysql --pager test1 | tar x
the tar file does not get written to /usr/local/test1 but i still dont
get my untared files? write permissions are ok?
what
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
At 11:03 -0500 11/19/03, Denis Mercier wrote:
i also tried:
use my_db;
select * from my_table;
so when i try shell mysql --pager test1 | tar x
the tar file does not get written to /usr/local/test1 but i still
is adding in when it's not explictly running
'into dumpfile'
-Original Message-
From: Denis Mercier [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 1:55 PM
To: [EMAIL PROTECTED]
Subject: Re: piping blob into shell command (tar)
On Wed, 2003-11-19 at 12:26, Paul DuBois
At 13:55 -0500 11/19/03, Denis Mercier wrote:
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
At 11:03 -0500 11/19/03, Denis Mercier wrote:
i also tried:
use my_db;
select * from my_table;
so when i try shell mysql --pager test1 | tar x
the tar file does
shell mysql --pager test1 | tar x
the tar file does not get written to /usr/local/test1 but
i still dont
get my untared files? write permissions are ok?
what am i missing?
Have you verified that the mysql command actually writes
any output
:
mysql --skip-column-names test1 | more
use test;\nselect * from test;\n
\n's are added?
-Original Message-
From: Denis Mercier [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 1:55 PM
To: [EMAIL PROTECTED]
Subject: Re: piping blob into shell command (tar
To: [EMAIL PROTECTED]
Subject: Re: piping blob into shell command (tar)
On Wed, 2003-11-19 at 14:02, Paul DuBois wrote:
At 13:55 -0500 11/19/03, Denis Mercier wrote:
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
At 11:03 -0500 11/19/03, Denis Mercier wrote:
i also tried
one more idea:
try:
mysql --skip-column-names --raw test1 | tar xf -
-Original Message-
From: Denis Mercier [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 2:41 PM
To: [EMAIL PROTECTED]
Subject: Re: piping blob into shell command (tar)
On Wed, 2003-11-19 at 14
-Original Message-
From: Denis Mercier [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 2:41 PM
To: [EMAIL PROTECTED]
Subject: Re: piping blob into shell command (tar)
On Wed, 2003-11-19 at 14:02, Paul DuBois wrote:
At 13:55 -0500 11/19/03, Denis Mercier wrote
, November 19, 2003 2:41 PM
To: [EMAIL PROTECTED]
Subject: Re: piping blob into shell command (tar)
On Wed, 2003-11-19 at 14:02, Paul DuBois wrote:
At 13:55 -0500 11/19/03, Denis Mercier wrote:
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
At 11:03 -0500 11/19/03, Denis Mercier
Thanks Paul for your reply,I extend a little more myquestion and try to be more specific:
There is a command or function to call a shell script through a mysql server on a linux boxusing odbc as client?
---Mensaje original---
De: Paul DuBois
Fecha: martes 18 de noviembre de 2003
There is a command or function to call a shell script through mysql?
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
There is a command or function to call a shell script through mysql?
_ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
At 4:47 PM -0300 11/18/03, adburne wrote:
There is a command or function to call a shell script through mysql?
Invoke mysql, then issue a \h command and look in the output for
the line that begins with system.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
/local/test1 from my_table;
so when i try shell mysql --pager test1 | tar x
the tar file does get written to /usr/local/test1 which is the step i'm
trying to avoid, and nothing seems to get piped to tar?
i also tried:
use my_db;
select * from my_table;
so when i try shell mysql --pager test1
At 14:05 -0600 11/18/03, Paul DuBois wrote:
At 4:47 PM -0300 11/18/03, adburne wrote:
There is a command or function to call a shell script through mysql?
Invoke mysql, then issue a \h command and look in the output for
the line that begins with system.
I forgot to mention: The system command
:
use my_db;
select * into dumpfile /usr/local/test1 from my_table;
so when i try shell mysql --pager test1 | tar x
the tar file does get written to /usr/local/test1 which is the step i'm
trying to avoid, and nothing seems to get piped to tar?
Right, because you've told the SELECT to write its
i've tried so far,
I create a text file called test1:
use my_db;
select * into dumpfile /usr/local/test1 from my_table;
so when i try shell mysql --pager test1 | tar x
the tar file does get written to /usr/local/test1 which is the step i'm
trying to avoid, and nothing seems to get piped
and i'm trying to retrieve it and pipe it directly into tar
to decompress it, without first writing it to the hard drive,
here's what i've tried so far,
I create a text file called test1:
use my_db;
select * into dumpfile /usr/local/test1 from my_table;
so when i try shell mysql --pager
that should help you find out what is causing the crash.
2003-Nov-06 13:40:48 :: execution failed
2003-Nov-06 13:40:48 :: shutdown
-- Stop of listing ---
How-To-Repeat: View (edit if need ) run attached shell script IP.SH
Fix: N/A
Submitter-Id: [EMAIL PROTECTED]
Originator
In the third chapter of the MySQL manual I don't understand the mentioned shell.
Where must I type in this and the following instructions or what does it mean ?
Until now I have found and started the winmysqladmin.exe file. But how to continue ?
Stephan
For Windows, its the DOS prompt. Go to start/run and type cmd.
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Stephan Wölfel [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 12, 2003 12:27 PM
To: [EMAIL PROTECTED]
Subject: what means shell ?
In the third chapter
At 19:27 +0200 10/12/03, Stephan Wölfel wrote:
In the third chapter of the MySQL manual I don't
understand the mentioned shell. Where must I
type in this and the following instructions or
what does it mean ?
Until now I have found and started the
winmysqladmin.exe file. But how to continue
Stephan -
In the third chapter of the MySQL manual I don't understand the mentioned
shell. Where must I type in this and the following instructions or what
does it mean ?
Until now I have found and started the winmysqladmin.exe file. But how to
continue ?
The shell is the interactive
In the third chapter of the MySQL manual I don't understand the
mentioned
shell. Where must I type in this and the following instructions or
what
does it mean ?
Until now I have found and started the winmysqladmin.exe file. But how
to
continue ?
My mistake. The shell is, in fact
check the data, and nothing was entered. When I
run each statement on it's own (not from a script file, but in the shell)
Everything seems to work. It just doesn't work when you try to run it from a
script.
Any ideas?
Mike Tuller
--
MySQL General Mailing List
For list archives: http
Put the full path to mysql in the script...
Jeff
-Original Message-
From: Mike Tuller [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 1:07 PM
To: [EMAIL PROTECTED]
Subject: Shell Script to Insert Data
I am trying to create a script that will insert data. Right
now
The first line starts mysql.
When mysql exits, the second line does nothing, as it is not a valid
shell command.
try :
echo 'INSERT INTO table_name (column_name) VALUES (value)' | mysql
--user=root --password= Database_Name
Or put the second line in a file, and cat the file through
run the script, I check the data, and nothing was entered. When I
run each statement on it's own (not from a script file, but in the shell)
Everything seems to work. It just doesn't work when you try to run it from a
script.
Any ideas?
Mike Tuller
Unless I'm missing something, you can do
The way I usually do it is this..
I have a shell scipt called query
It contains:
/fullpath/mysql --user=root --password= Database_Name
I then make new scripts for the queries as such:
(query file name: Select_all.sql)
Select * from Table where blah=foo;
To run this I then execute
Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the
result of a SQL statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
Thanks in advance!
May be:
myvar
On Mon, Jun 23, 2003 at 06:37:17PM -0500, Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the result of a SQL
statement into a variable.
You mean Bourne shell.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
Joseph Bueno wrote:
Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the
result of a SQL statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
But this is more
On 24-Jun-2003 Fred Whipple wrote:
snip
Don't forget to use '-B' in order to make the output silent except for
the results:
and -N to suppress column names.
snipagain
2. you should stick your password (which shouldn't match
your UNIX password) in a textfile readable only by you
I am writing a shell script using Born Shell. I am trying to get the result of a SQL
statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
Thanks in advance!
of mysql connection between
cgi and shell
Hi,
I am coding a cgi program to query the records from the mysql tables. When
I execute the sql query (which is a join operation on two tables) in the
mysql shell, the results are shown correctly. However, if I use cgi script
to execute the same query
Hi,
I am coding a cgi program to query the records from the mysql tables. When
I execute the sql query (which is a join operation on two tables) in the
mysql shell, the results are shown correctly. However, if I use cgi script
to execute the same query, the web browser just crashed after
Hi, all,
sql, query.
I try to use a mysqldump file from development database and insert back into
production database on another server.
bkp_dbname.sql is copied over to prodution, and I am using the following
command at production.
shell mysql -ujqu -pjqu1234@ dbname bkp_dbname.sql
File
At 22:10 + 11/21/02, Jannie Qu wrote:
Hi, all,
sql, query.
I try to use a mysqldump file from development database and insert
back into production database on another server.
bkp_dbname.sql is copied over to prodution, and I am using the
following command at production.
shell mysql
1 - 100 of 150 matches
Mail list logo