I found the error. I was using "" around the "+" where I should have been
using '', like '+'.
SELECT
IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
- ',CMEYR))),' - ')
FROM
TABLE;
Thanks
#x27; - ')
FROM
TABLE;
Is it not possible to nest an "if, then, else" statement?
Thanks.
John Halladay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
If I am querying a field that has either "a" or "b" as a value and I want a
second field's value to be dependant on the first field's value, how would I
right that?
SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table;
The IF,THEN,ELSE is the only thing I can think of, but that
: Thursday, February 15, 2001 1:36 PM
To: John Halladay
Cc: MySQL List (E-mail)
Subject: Re: Percent?
SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table;
John Halladay <[EMAIL PROTECTED]> wrote:
I can't find this in the manual (maybe I'm looking in the wro
I can't find this in the manual (maybe I'm looking in the wrong place). How
do I show a value as a percent? For example.
SELECT data1, data2, data3 FROM table;
Assuming data1 is 0.25, how do I show it as 25%?
SELECT PERC(data1), data2, data3 FROM table;?
Thanks.
Joh
ything, where can I change the setting so I can read/write and not just
read? I also have another table that lets me make changes, but won't let me
save them.
Thanks,
John Halladay
-
Before posting, please check:
htt
If I am using MS Access and linking to tables in MySQL through MyODBC, what
is the equivalent format of a checkbox (Yes/No) in MySQL?
Would it be ENUM('Yes','No') or ENUM('True','False')? All caps TRUE, YES,
etc.?
Thanks ahea
reating the table in MySQL? Would I need to create a composite key, etc.?
Thanks.
John Halladay
BISYS - Commission Accounting
Phone: 801.532.6660 x7973
Fax: 801.533.7879
www.ascensus.com
Life LTC Annuities Variable Disability
somehow use the command CONNECT [] to change the database?
-Original Message-
From: Scott Baker
To: John Halladay; MySQL List (E-mail)
Sent: 1/31/2001 2:09 PM
Subject: Re: MyODBC - but how?
You just create a DSN in the control panel, and tell your ODBC compliant
software to use that data
I have just installed MyODBC on my machine (Windows ME) and everything is
working fine, but I've looked through the manual and I can't find anything
showing commands on how to connect to other databases. Can someone point me
in the right direction?
Thanks.
Joh
00 to automate
reporting and queries for my work. It will be on my machine and only used
by myself.
Thanks ahead of time for your input.
John Halladay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Normally when you log in you would type:
->mysql -u username -p [Enter]
It would then prompt you for a password if you have one.
(By the way, substitute "username" with your username.)
It shouldn't matter what prompt you're in, root, etc.
John Halladay
-Original
will start up
automatically when I boot up Linux? (I know it's a little off the MySQL
subject, but I figured someone would have a similar setup.)
Thanks,
John Halladay
-
Before posting, please check:
http://www
To install will you be using a tarball or RPM?
-Original Message-
From: Stephen Lambert,CSI [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 11:18 AM
To: [EMAIL PROTECTED]
Subject: installing and configuring Mysql on red hat linux 6.2
Hi, I would like to know where i can find i
"Mirror" is the word you're looking for.
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 11:55 AM
To: MySql list
Subject: Replicating MySQL
Hello,
How could we replicate our MySQL DB from one server to another? As a back
up measure,
15 matches
Mail list logo