-8939
Fax 303-778-0378
[EMAIL PROTECTED]
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 04, 2008 1:14 PM
To: Eric Lommatsch
Cc: mysql@lists.mysql.com
Subject: Re: Question about Averaging IF() function results
Eric,
I'd re
---
HUM300 | 6.000 |
6.000 | Null| 6.000 |6.000
| 6.000
HUM301 | 6.000 |
6.000 | 6.000 | 6.000 |6.000
| 6.000
I tried usi
6.000 | 6.000
|6.000 | 6.000
I tried using the if function without a false answer and I am getting a
syntax error when I do this.
If it is possible for me to get this correct result in MySQL, can someone
provide me with the correct query syntax to get these r
yone is convinced:
mysql> select fname, lname
-> from employee
-> order by if(fname is not null, 1, 2);
Works. Well, it executes, but it does not order by
the first or second column, just the natural order of
the table it seems.
One added feature is that our 'order by if'
UPDATE table SET d='complete' WHERE a=0 AND b=0 and c=0;
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 3:58 PM
To: MySQL List
Subject: if function?
Is there a way to write an if statement in mysql to affect the following?...
if
Is there a way to write an if statement in mysql to affect the following?...
if field a=0,b=0,c=0 then update d='complete'
where the table consists of...
a int(1),
b int(1),
c int(1),
d char(8)
|a |b |c |d |
|1 |0 |0 |null |
|1 |1 |0 |nul