Nesting

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/ (the list archive)

RE: Nesting

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 for your help. John Halladay -Orig

Percent?

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. John Halladay

RE: Percent?

: 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 wrong place). How do I show

MS Access - This Recordset is not updateable

n 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: http://www.mysql.com/

PK, SK, FK . . . ?

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 - Before

RE: MyODBC - but how?

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

MyODBC - but how?

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. John Halladay

Apache - MySQL - PHP (Auto-start Apache)

that it 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.mysql.com

RE: newbie grant problems

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 Message-

RE: Replicating MySQL

"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