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
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
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
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 administr
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
inte
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 administr
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
S
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 Dir
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 -u -p < /path/file.sql
After increasing the varia
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, wrote:
> 2012/10/03 20:35 +0700, Morning Star
> $ ech
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;
;value1","value2","value3" );
I believe that this is what Michael was eluding to as well...
garotconk...@yahoo.com
From: Garot Conklin
To: Michael Dykman ; Morning Star
Cc: "mysql@lists.mysql.com"
Sent: Wednesday, October 3
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
e command you are trying to run.
- michael dykman
On Wed, Oct 3, 2012 at 9:35 AM, Morning Star
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",&
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'
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.
>>> 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@'%' IDENTIFIE
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
>> 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 Mend
> 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 'whatev
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';
Does
> 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
> 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 mysql.
' INDENTIFIED BY 'ben';
Does this help?
Ben
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
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 '%'
[...]
Th
> 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
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
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 and
process out of
suspension 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 d
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 + telefon
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 ma
:q!".
On Sep 8, 2006, at 8:54 PM, Pastor Steve wrote:
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
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
s:
show 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:
>
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 --w
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 ti
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]
ation.
>
> 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 ("Umlaute")
>I used the LOAD DATA L
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
mmand (for bash: echo -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 int
ieve 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, releasenotes,
> checksu
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, usermanua
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 th
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 alway
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 exact
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 th
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 to
To: [EMAIL 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=
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`
#Prefix_Produc
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.
r 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 < createdb.sql
Then in createdb.sql
CONNECT Blah;
CREATE TABLE $date (
.
) TYPE=MyISAM;
B
ql List
Subject: RE: 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 pr
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 -
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 &quo
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
Thanks Paul for your reply, I extend a little more my question and try to be more specific:
There is a command or function to call a shell script through a mysql server on a linux box using odbc as client?
---Mensaje original---
De: Paul DuBois
Fecha: martes 18 de noviembre
r [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 Merc
rs
>
> to see if it works
>
>
> > -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)
> >
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)
>
9, 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:
> &g
ng FILE_LOAD().
before:
use test;
select * from test;
after:
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,
; >> >> >use my_db;
> >> >> >> >select * from my_table;
> >> >> >> >
> >> >> >> >so when i try shell> mysql --pager < test1 | tar x
> >> >> >> >
> >
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;
>> >> >
a text that mysql 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 comma
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;
> >> >> >
> >> >>
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 writte
ieve 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;
> >> >se
ob field
>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/loc
st 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 < test1 | tar
xt 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 to tar?
Right, be
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
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?
i also tried:
use my_db;
select * from my_t
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, US
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í
en/Crashing.html contains
information 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
>
>> 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 fil
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
&g
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. B
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 "
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 c
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 th
e");
After I 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 mis
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 ca
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 scri
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
--
MySQL General Mailing Lis
On 24-Jun-2003 Fred Whipple wrote:
> Don't forget to use '-B' in order to make the output silent except for
> the results:
>
and -N to suppress column names.
> 2. you should stick your password (which shouldn't match
> your UNIX password) in a textfile readable only by you so that
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 t
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
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!
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!
ference 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
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 a
;[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: How to use foreign_key_check=0 at shell prompt level?
Date: Thu, 21 Nov 2002 16:25:04 -0600
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 produc
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> my
1 - 100 of 158 matches
Mail list logo
