Simple Question: MySQL and Shell Scripts

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!

Select statement with a field name that is a number?

variation, I get the same result where MySQL keeps evaluating the WHERE statement like a mathematical equation. -Zach

table locking

Is there an explanation somewhere about the rules mysql uses when lock tables? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Calculating Age

do I... A) bring these two fields together B) assign a day value to calculate age, if needed C) calculate the age I was trying something like the following syntax but this doesn't combine the fields or use a date format. SELECT (TO_DAYS(NOW())-TO_DAYS(???)/365) FROM table; Thank you. Zach C

RE: Calculating Age

Ah, good idea. That should resolve my issue. Thanks! Zach -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 2:08 PM To: Zach Curtis; [EMAIL PROTECTED] Subject: RE: Calculating Age > I am trying to calculate an approximate

Decrypting PASSWORD() from MySQL

ot;Could not execute database query:" . mysql_error() . ""; $row = mysql_fetch_array($result); $userName = "$row[userName]"; $password = "$row[password]"; $email = "$row[email]"; Thank you. Zach Curtis Programmer/Analyst POPULUS --

RE: Decrypting PASSWORD() from MySQL

/decipher Thanks, Zach -Original Message- From: Matt Wagner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:52 PM To: Zach Curtis Cc: [EMAIL PROTECTED] Subject: Re: Decrypting PASSWORD() from MySQL Zach Curtis writes: > I have a form for a user to request their forgot

Reporting Tool

(e.g., tables, graphs, bar charts, pie charts, etc.). The data would of course need to be real-time. Any suggestions? Zach Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual)

How do I get optimal performance in this situation?

just throw the columns from table wibble into table bar as to avoid two queries? Or perhaps the search speed of MySQL is linear, so having a smaller table will speed up queries? *Any* comments on implementation would be much appreciated, Thanks, Za

DATE - longtext

Hi I have a database whose table has a column, which has a datatype longtext. I then try a query mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND '10/21/2 003'; I thought it would fail since the datatype isnt DATE nor TIMESTAMP. But from the result, it seems to work. 1

DATE

Hi 1 - I have a column whose datatype is longtext. Its content is 08/06/2003; I created a new column whose datatype is DATE. Its content is null now. How do write a SQL statement that inputs each row from 08/06/2003 in the old column to 2003-08-06 in a new column ? Eg: old column name - my_date ne

DATE

Hi How do I rename a new column ? How do I drop a column ? >From MySQL documentation, it refers to rename/drop table. I dont want to do that. Thanks Paul for your aid. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Rename/Create Database from Existing Database

Hi 1- Is there a command to rename an existing database ? 2- If not, how does one create a new database from an existing database ? could you show me the steps? Any help is appreciated. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

Help - Convert Date from longtext to MySQL date format

Hi I have a few tables in a database Z, namely table a b c In table a, the columns are my_date - longtext num - int(11) eg: mysql> select * from a; +--+--+--+ | my_date | x| +--+--+ | 08/06/2002 |1 | | 08/07/2002 |2 | +--+--+--

Duplicate Record

Hi 1) Suppose, in a file, say testfile.sql, it contains a line eg: LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ; And further suppose the record in file mlc_stat_ already exists in the table mlc. Does MySQL have the ability to stop inserting this duplicated record

Duplicate Record

Hi 1) Suppose, in a file, say testfile.sql, it contains a line eg: LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ; And further suppose the record in file mlc_stat_ already exists in the table mlc. Does MySQL have the ability to stop inserting this duplicated record

RE: Duplicate Record

> -Original Message- > From: Wong Zach-CHZ013 > Sent: Wednesday, May 22, 2002 7:11 PM > To: [EMAIL PROTECTED] > Subject: Duplicate Record > > Hi > 1) Suppose, in a file, say testfile.sql, > it contains a line > eg: > LOAD DATA INFI