Dear all,
I am research on several commands through which I can monitor the size
of specific data of tables in different . I want to write a script that
fetches the data of different database tables databases too daily and
write it into a file .
Is there is any way or commands to achieve
Dear all,
I am working on some common tasks that need to be performed on regular
intervals in a large Database Servers. I find below lists of tasks that
need to be performed and Please tell me if i missed some.
1. Tacking Daily, Weekly Backups.
2. Finding Space Occupied and Remaining in Data
Hi Alex, all!
Alex Katebi wrote:
Any information on how to run the test scripts for the embedded client.
Call the test script, mysql-test-run.pl, and pass it the option
--embedded-server
It does not support replication or cluster, so you should add
--skip-rpl --skip-ndbcluster
Regards
Any information on how to run the test scripts for the embedded client.
Thanks,
-Alex
='000273999'
UPDATE cliente SET ciudad='AREQUIPA' WHERE idCliente='00454507'
.
to only have the option to edit the column ciudad for some row
i hope you see my point now
thanks in advanced
--
View this message in context:
http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts
List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
View this message in context:
http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16524400.html
Sent from the MySQL - General mailing
Hi,
if i have for example
a simple table call person
with 'id' and 'name' how columns
i can do a backup and get some file (A.sql)
with all the inserts statements
here, all fine
but
how i can do this?
Have a look at the 'mysqldump' command line utility.
It goes something like
statements
its possible do this?
even worst, if a have a table with 20 columns
i need the way to generate the same B.sql
but with my desired columns to update
thanks in advanced
--
View this message in context:
http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups
Where possible I use distro builds of applications (let them worry about
security updates and testing, means I don't need build tools on a
production server), but all the distros I've checked use their own
startup scripts which do not allow me to use mysqlmanager (or even
mysqld_multi) to run
hi,
Tanks for your help, finally i found the source command. It work like
this:
mysql source /Lhome/geruppa/mhc/Pack_Ref_web/prova.sql
2007/11/9, Michael Gargiullo [EMAIL PROTECTED]:
On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote:
Hi everybody
I'm writing a function
Hi everybody
I'm writing a function script in a flat file using vim, now i would like
load it into my sql, there is some command to do it similar to load data
into to fill tables?
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina
You have basic instruction SELECT (for selection) and INSERT (for write in
table)
What case :
. Take data in one table and transfer it in other table ( select / insert )
. Take data in a file and insert it in a table ( tools of conversion)
2007/11/9, Pau Marc Munoz Torres [EMAIL PROTECTED]:
Hi
On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote:
Hi everybody
I'm writing a function script in a flat file using vim, now i would like
load it into my sql, there is some command to do it similar to load data
into to fill tables?
thanks
Sure,
From command line:
mysql
on two
locations to be even safer.
In my setup I now have 3 my.sh scripts executed at the same time through a
cronjob. Could it be problematic to do this at the same time or does it not
matter? The databases aren't large.
Cheers,
Andreas
I finally got the script working. Seems to run smooth on my FreeBSD 4.11system:
MYSQLDUMP=`which mysqldump 2/dev/null` ||
MYSQLDUMP=/usr/local/bin/mysqldump
MYSQLDUMP_ARGS=--opt --extended-insert -h localhost -umyuser -pmypassword
mydb
ARCHDIR=/backup/mysql
NAME=db_dump
# Remove archives older
Good morning Andreas -
The --opt flag implies --extended-insert, in addition to some other
options, to generate an optimized (fast) dump file. See man
mysqldump. You don't need both but having both shouldn't hurt.
To restore, pipe your dump file back into the mysql client, a la
mysql -u user
: Recommended backup scripts for mysql databases
Andreas, if you are only using MyISAM tables, the included mysqlhotcopy
script may work for you. We used it at my previous employer with good
results. We would run it to create a snapshot of our data files every
day, then run a network backup
Tim Lucia wrote:
I am in the process of designing the backup procedures for a soon-to-be
production DB. I have gone back and forth on mysqldump and mysqlhotcopy.
As I see it (for MyISAM tables), the hot copy backs up faster, restores
faster, but does not allow for selective restores (Hello,
backup scripts for mysql databases
Andreas, if you are only using MyISAM tables, the included mysqlhotcopy
script may work for you. We used it at my previous employer with good
results. We would run it to create a snapshot of our data files every
day, then run a network backup utility that backed
Thanks for the examples. I haven't been able to get them to work yet.
Here's what I tried:
MYSQL=`which mysql 2/dev/null` || MYSQL=/usr/local/bin/mysql
MYSQL_ARGS=--opt -uroot -pmypassword db
ARCHDIR=/backup/mysql
NAME=db_dump
# Remove archives older than 64 days
find ${ARCHDIR} -type f -mtime
Looks like your full command would end up being:
mysqldump /usr/local/bin/mysql --opt -uroot -pmypassword db
which makes little sense. (You don't need that ${MYSQL} in there).
Instead, maybe what you want is to use an environment variable for
mysqldump, a la
MYSQLDUMP=`which mysqldump
On 6/29/06, Tim Lucia [EMAIL PROTECTED] wrote:
I am in the process of designing the backup procedures for a soon-to-be
production DB. I have gone back and forth on mysqldump and mysqlhotcopy.
As I see it (for MyISAM tables), the hot copy backs up faster, restores
faster, but does not allow for
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 9:26 AM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Recommended backup scripts for mysql databases
Hi Tim - those are all important considerations, yes.
In my mind neither
-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 9:26 AM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Recommended backup scripts for mysql databases
Hi Tim - those are all important considerations, yes.
In my mind neither mysqldump nor mysqlhotcopy
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 6:01 PM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Recommended backup scripts for mysql databases
That's a good thought, Tim - file grep could provide a quick means to
access the data
Those warnings always give me pause, too - but I used mysqlhotcopy in
production for about 5 years at my previous place of employment.
Probably like the warnings about threading in perl 5.8 - been using
threads in production for nearly 2 years without a problem.
Only 2 problems with mysqlhotcopy
Hi,
I have a few FreeBSD servers running various web/database things and I'm
looking for a good a reliable backup script that I can run through a
cronjob. I'm currently running the latest version of mysql323, but will
upgrade to version 4.1 soon aswell as upgrade most of the servers to the
latest
On 6/27/06, Andreas Widerøe Andersen [EMAIL PROTECTED] wrote:
Hi,
I have a few FreeBSD servers running various web/database things and I'm
looking for a good a reliable backup script that I can run through a
cronjob. I'm currently running the latest version of mysql323, but will
upgrade to
On Tue, Jun 27, 2006 at 08:19:41AM -0300, Daniel da Veiga wrote:
On 6/27/06, Andreas Widerøe Andersen [EMAIL PROTECTED] wrote:
Hi,
I have a few FreeBSD servers running various web/database things and I'm
looking for a good a reliable backup script that I can run through a
cronjob. I'm
Andreas, if you are only using MyISAM tables, the included mysqlhotcopy
script may work for you. We used it at my previous employer with good
results. We would run it to create a snapshot of our data files every
day, then run a network backup utility that backed up the snapshot (but
did not
At 23:00 +0100 14/6/06, Graham Reeds wrote:
1) You may have a bogus hidden character in your SQL file. If you
look at it with a text editor (BBEdit, TextWrangler, etc), with the
show invivisbles feature on, do you see unusual stuff? Sounds
strange but I've seen stranger.
Took a brief look
do to make the database creation scripts
MySQL4 compliant. The CHARSET was the easy one - just change it to
CHARACTER SET but the next one was more tricky:
The problem I am having is that version 4 fails giving a syntax error
for the single quotation marks. It appears the script (which
.
2) You could work around this problem a different way ...
- create a 5.0 database yourself using the standard supplied scripts,
perhaps on your own workstation
- dump your new database structure using mysqldump with the flag
--compatible=mysql40
which should create a file suitable
decided to see what I can do to make the database creation scripts
MySQL4 compliant. The CHARSET was the easy one - just change it to
CHARACTER SET but the next one was more tricky:
The problem I am having is that version 4 fails giving a syntax error
for the single quotation marks. It appears
untoward. Nor did side by side comparison show up anything.
2) You could work around this problem a different way ...
- create a 5.0 database yourself using the standard supplied scripts,
perhaps on your own workstation
- dump your new database structure using mysqldump with the flag
a different way ...
- create a 5.0 database yourself using the standard supplied scripts,
perhaps on your own workstation
- dump your new database structure using mysqldump with the flag
--compatible=mysql40
which should create a file suitable for piping into a MySQL 4.0 server
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: [Error while runnign ./scripts/mysql_install_db --user=mysql]
Description
Is it possible to run nested scripts in MySQL?
If I want to run a script called TestA1.sql where TestA1.sql contains:
select * from Sample.emp;
all I need to do is go to the MySQL command prompt and enter:
\. TestA1.sql
That's a single, un-nested script and it works fine.
Now, suppose I
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Monday, January 16, 2006 09:10
To: mysql
Subject: Nested scripts in MySQL?
Is it possible to run nested scripts in MySQL?
I tried this with success. Create a file that contains lines like this:
\. today.sql
Subject: RE: Nested scripts in MySQL?
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Monday, January 16, 2006 09:10
To: mysql
Subject: Nested scripts in MySQL?
Is it possible to run nested scripts in MySQL?
I tried this with success. Create a file that contains lines like
As it turns out, it is entirely possible to nest scripts to multiple levels.
For instance I now have:
Create_And_Load_Tables.sql
---
\. Create_Tables.sql
\. Load_Tables.sql
---
Create_Tables.sql
-3895
Cell: 716-432-4978
[EMAIL PROTECTED]
Tom Crimmins [EMAIL PROTECTED]
03/03/2005 03:06 PM
To
[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
RE: backup scripts
Kelly,
You can find out what user mysqld is running as with the following:
#ps axu | grep mysqld
To change
/en/backup.html
I also attempted to follow these directions, to no avail:
--
mysqlhotcopy, etc is great - but using it (and most other myql automation
scripts) requires placing a user/password on the command line for all/some
to see (ps axw)
There doesn't appear
these directions, to no avail:
--
mysqlhotcopy, etc is great - but using it (and most other myql
automation scripts) requires placing a user/password on the command
line for all/some to see (ps axw)
There doesn't appear to be a way to place the user/pass
/old-client.html
I followed the directions from:
http://dev.mysql.com/doc/mysql/en/backup.html
I also attempted to follow these directions, to no avail:
--
mysqlhotcopy, etc is great - but using it (and most other myql
automation scripts) requires placing
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
Hi all,
I'm going to test some stuff with scripts that include Stored
Procedures/Functions and a lot more.
Could someone provide me with some huge scripts that
include tables, indices, FKs and some Stored Prcedures
or Functions?
If so, please do so - much appreciated.
With regards,
Martijn
Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are run
through the web browser. And they do access the same database, and the
same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect to mysql as the same user
I have one database that is currently being accessed by 2 scripts which query the database. One is
for me to administer the db contents. The other is for public display, and so has the final buttons
disabled for 'Delete', 'Add', 'Modify', 'Dump', and 'Restore'. Users can go through the motions
a mis-count. How is this possible? Is there a step I'm missing
because I'm using 2 different scripts to access the same tables? That
doesn't make sense. Can someone shed some light on what might be happening
here?
Web caching? Flushing tables after your delete?
--
Brian Reichert
it's
not just a mis-count. How is this possible? Is there a step I'm missing
because I'm using 2 different scripts to access the same tables? That
doesn't make sense. Can someone shed some light on what might be happening
here?
Web caching? Flushing tables after your delete?
Yes, I had thought
it's
not just a mis-count. How is this possible? Is there a step I'm missing
because I'm using 2 different scripts to access the same tables? That
doesn't make sense. Can someone shed some light on what might be happening
here?
Web caching? Flushing tables after your delete?
I just checked
the other script. The admin script shows 102 records
and the other shows 103. The record does show up in the 'public'
script, so it's not just a mis-count. How is this possible? Is there
a step I'm missing because I'm using 2 different scripts to access
the same tables? That doesn't make sense. Can
in the 'public'
script, so it's not just a mis-count. How is this possible? Is there
a step I'm missing because I'm using 2 different scripts to access
the same tables? That doesn't make sense. Can someone shed some
light on what might be happening here?
Web caching? Flushing tables after your delete?
I
show up in the 'public'
script, so it's not just a mis-count. How is this possible? Is
there a step I'm missing because I'm using 2 different scripts to
access the same tables? That doesn't make sense. Can someone shed
some light on what might be happening here?
Web caching? Flushing tables
shows 103. The record does show up in the
'public' script, so it's not just a mis-count. How is this
possible? Is there a step I'm missing because I'm using 2
different scripts to access the same tables? That doesn't make
sense. Can someone shed some light on what might be happening here?
Web
shows 103. The record does show up in the
'public' script, so it's not just a mis-count. How is this
possible? Is there a step I'm missing because I'm using 2
different scripts to access the same tables? That doesn't make
sense. Can someone shed some light on what might be happening here?
Web
Amer Neely wrote:
snip
OK, obviously a bit more background seems to be in order.
My site is hosted but I am not the administrator. I have 2 perl scripts,
behaving as already described. I also have phpMyAdmin access to my
databases. I don't have command line access to the server.
Well, that's
Amer Neely wrote:
snip
I'm pretty sure it's not. With a properly functioning mysql server,
you need neither FLUSH TABLES nor the RELOAD privilege to delete a row
from a table. See the manual for a description of FLUSH TABLES
http://dev.mysql.com/doc/mysql/en/FLUSH.html.
I did and imagine my
Michael Stassen wrote:
Amer Neely wrote:
snip
OK, obviously a bit more background seems to be in order.
My site is hosted but I am not the administrator. I have 2 perl
scripts, behaving as already described. I also have phpMyAdmin access
to my databases. I don't have command line access
Have you tried running this from the mysql monitor?
-Original Message-
From: Andre MATOS
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 7/8/04 5:33 PM
Subject: RE: Scripts - ERROR
Hi,
I tried but didn't work. Here is my script
Hi List,
Let's suppose that I have a script to create one database (tables,
indexes, etc).
How can I call another script from this script? For example:
DROP DATABASE test;
CREATE DATABASE test;
(here call another script)
back to the previous script
Thanks.
Andre
--
Andre Matos
[EMAIL
Have you tried writing the script using the source command?
drop database;
create database;
source populate_db;
-Original Message-
From: Andre MATOS
To: [EMAIL PROTECTED]
Sent: 7/8/04 12:20 PM
Subject: Scripts
Hi List,
Let's suppose that I have a script to create one database
-
From: Andre MATOS [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 08, 2004 10:21 AM
To: [EMAIL PROTECTED]
Subject: Scripts
Hi List,
Let's suppose that I have a script to create one database (tables,
indexes, etc).
How can I call another script from this script? For example:
DROP DATABASE test
Subject: Scripts
Hi List,
Let's suppose that I have a script to create one database (tables,
indexes, etc).
How can I call another script from this script? For example:
DROP DATABASE test;
CREATE DATABASE test;
(here call another script)
back to the previous script
Thanks
hi ppl, im a newbie to mysql but been using oracle for quite sometime
now and i found that mysql is not bad at all :)
i was just wondering if is there an equivalent scripting method of
coding like plsql scripts in mysql... ?
TIA
Dudley F. Cañas wrote:
hi ppl, im a newbie to mysql but been using oracle for quite sometime
now and i found that mysql is not bad at all :)
i was just wondering if is there an equivalent scripting method of
coding like plsql scripts in mysql... ?
TIA
Stored Proceedures are currently
Hello,
This is an announcement to all MySQL developers. I have opened my web site
www.SQL-Scripts.com up to MySQL . This means that you can now search for
scripts for MySQl and other database system on this site.
www.SQL-Scripts.Com is targeted at becoming the number on search engine
06:24 am, Sagara Wijetunga wrote:
Hi all
Is it possible to span a database transaction across
multiple CGI scripts? That is, start transaction and
lock some records in one CGI script and update and
commit in another CGI script.
Here is an example: I have a accounts database. Only
one user
Hi all
Is it possible to span a database transaction across
multiple CGI scripts? That is, start transaction and
lock some records in one CGI script and update and
commit in another CGI script.
Here is an example: I have a accounts database. Only
one user should edit a given account at any given
On 02/26/2004 09:02 AM Scott Haneda wrote:
As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location=/Volumes/foo/sql_dumps/
# set db_list to the list of databases
db_list=`echo show databases |
on 02/27/2004 09:53 AM, Adam Hardy at [EMAIL PROTECTED] wrote:
On 02/26/2004 09:02 AM Scott Haneda wrote:
As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location=/Volumes/foo/sql_dumps/
# set
As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location=/Volumes/foo/sql_dumps/
# set db_list to the list of databases
db_list=`echo show databases | /usr/local/mysql/bin/mysql -N -u
-p`
for db
As per the reco of someone on this list, I created a bash script that runs
once a day to do the following:
# set path to final destination
location=/Volumes/foo/sql_dumps/
# set db_list to the list of databases
db_list=`echo show databases | /usr/local/mysql/bin/mysql -N -u
-p`
for db
Hey guys,
Im trying to build a login system with
Phpmyadmin and php, with dreamweaver.
I use the coder view to code my pages.
Would any of you guys be willing to help a rookie
Out. Ive tried to read and follow tutorials but
I have a hard time manipulating it towards my code and site!
Anyone
Hi all,
I'am getting this error when I try to run any of the sql-bench tests.
For instance, here is an attempt to run the test-connect script. This
happens to me when I try any of the scripts. I attempted to change the
location my perl install at the beginning of the script(RH 8.0) can
anyone
script. This
happens to me when I try any of the scripts. I attempted to change the
location my perl install at the beginning of the script(RH 8.0) can
anyone help me with this? Anyone else with Redhat run into this
problem?
Thanks
./test-connect
Can't locate DBI.pm in @INC (@INC
At 23:11 -0500 11/24/03, jason steig wrote:
Hi all,
I'am getting this error when I try to run any of the sql-bench tests.
For instance, here is an attempt to run the test-connect script. This
happens to me when I try any of the scripts. I attempted to change the
location my perl install
Thank you much!
-Original Message-
From: Michael Weiner [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 11:18 PM
Cc: [EMAIL PROTECTED]
Subject: Re: FW: running sql-bench scripts redhat 8.0
looks like you'll need to install the perl-DBD-mysql rpm to satisfy the
requirement
Well looks like it has quite a few dependencies. I'll have to install
these other dependencies
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 12:10 AM
To: jason steig
Subject: RE: FW: running sql-bench scripts redhat 8.0
Thank you much
I'am having trouble running all the scripts in sql-bench. It seems to be an issue
with the location of my perl install. I tried to change the perl location at the
start of the script to the location of my perl install /usr/bin but that didn't fix
the issue. has anyone else had this issue
At 9:13 -0500 11/23/03, Jason Steig wrote:
I'am having trouble running all the scripts in sql-bench. It seems
to be an issue with the location of my perl install. I tried to
change the perl location at the start of the script to the location
of my perl install /usr/bin but that didn't fix
Hi, im using this script to show the query results, basically it shows
multiple results in multiple pages, when more than one result are found it
shows the first one and on the bottom of the pages it shows the number of
pages that remains, but fot some strange reason when you click on the first
Hi,
Hope someone can guide me how to generate sql scripts in Mysql?Thanks.
regards,
florence
Yahoo! Games
- Who Wants to Be A Millionaire? Play now!
in batch mode, use
mysql -t. To echo to the output the commands that are executed, use
mysql -vvv.
You can also use scripts in the mysql command-line prompt by using the
source command:
mysql source filename;
Andy
-Original Message-
From: florence florence [mailto:[EMAIL PROTECTED]
Sent: 12
Hello.
I have to do an script to create MySQL users, the name
of the new user have to be a parameter of the script.
I have no idea, someone can helps me.
I'm an NT user.
Thanks:
Enrique Andreu
___
Yahoo! Messenger - Nueva versión GRATIS
Super
[mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 12:36 PM
To: [EMAIL PROTECTED]
Subject: Scripts with arguments
Hello.
I have to do an script to create MySQL users, the name
of the new user have to be a parameter of the script.
I have no idea, someone can helps me.
I'm an NT user
Hello, I think I have explained bad. I want to pass
the arguments to the sql script.
The argument is for the sql script.
For example:
myscript.sql should be:
GRANT ALL PRIVILEGES ON *.* TO 1@'%'
where 1 would be parameter 1
I want to do something like that:
dosmysql mysql -u root -p
* Enrique Andreu
Hello, I think I have explained bad. I want to pass
the arguments to the sql script.
The argument is for the sql script.
For example:
myscript.sql should be:
GRANT ALL PRIVILEGES ON *.* TO 1@'%'
where 1 would be parameter 1
I want to do something like that:
dosmysql
Hi,
Would anyone explain me why the startup scripts check
for command line arguments and the contents of
/etc/my.cnf right after setting the env variables such
as basedir, pid-file and so?
if the MySQL code and scripts are expected to be on a
specific hardcoded location (yeah, right we could
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 26 June, 2003 14:53
Subject: Uploading scripts in MySQLGUI
Hi there,
Is there a way to upload a saved script file into the GUI window to
execute? On the GUI interface, there are SAVE, EXECUTE buttons. But I
cannot find anything
Hi there,
Is there a way to upload a saved script file into the GUI window to
execute? On the GUI interface, there are SAVE, EXECUTE buttons. But I
cannot find anything for uploading, even copying functions.
Thanks for the help.
Regards,
Sean Tang
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:
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!
1 - 100 of 218 matches
Mail list logo