On 12/9/2014 9:10 PM, h...@tbbs.net wrote:
2014/12/09 15:20 -0600, Peter Brawley
Nope.
And why not? Because no one bothered to implement it? Now I (for the first time?) looked at
"forums.mysql.com" and see more topics than on "lists.mysql.com". The former is
just more with-it,
2014/12/09 14:25 +, Martin Mueller
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be
very useful for update operations, but I can't get it right.
If I read the documentation correctly, it should be possible to say
something like
UPDATE X
if WORD like '
2014/12/09 15:20 -0600, Peter Brawley
Nope.
And why not? Because no one bothered to implement it? Now I (for the first
time?) looked at "forums.mysql.com" and see more topics than on
"lists.mysql.com". The former is just more with-it, I guess.
I believ that one could both by e
On 2014-12-09 9:55 AM, Johan De Meersman wrote:
- Original Message -
From: "Sándor Halász"
Subject: Re: forum vs email
That is, this list, right? What does it lack (besides readers)?
This list interacts with the forums on mysql.com?
Nope.
PB
-
Every thread here matches one on
Hello Martin,
On 12/9/2014 9:25 AM, Martin Mueller wrote:
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would
be very useful for update operations, but I can't get it right.
If I read the documentation correctly, it should be possible to say
something like
UPDATE X
if W
- Original Message -
> From: "Sándor Halász"
> Subject: Re: forum vs email
> That is, this list, right? What does it lack (besides readers)?
This list interacts with the forums on mysql.com? Every thread here matches one
on there, and vice versa? (Honest question; I hardly ever visit th
- Original Message -
> From: "Richard Reina"
> Subject: Specking a small MySQL server
>
> somewhat of an energy hog and is due to be replaced. I was considering
> replacing it with a lap-top so as to conserve energy and because a laptop
> has a built in battery backup. Currently I have a
You can use your login inline with nested IF expressions:
insert into foo(id,comment)
values(17, IF(WORD like 'a%','a',IF(word like 'b%','b',null)));
On Tue, Dec 9, 2014 at 9:50 AM, wagnerbianchi.com
wrote:
> You can do that, but, perhaps the only chance to have it updating a row
> bas
You can do that, but, perhaps the only chance to have it updating a row
based on a condition is developing a Stored Procedure or even having a
BEFORE Trigger associated with the main table. Those ways, you can test the
sent value and decide on what UPDATE you will execute afterwards. Consider
that
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would
be very useful for update operations, but I can't get it right.
If I read the documentation correctly, it should be possible to say
something like
UPDATE X
if WORD like 'a%' SET COMMENT = 'a'
elseif WORD like 'b%' SET CO
10 matches
Mail list logo
