fre 2006-06-23 klockan 01:52 -0400 skrev Michael Stassen:
> Thomas Lundström wrote:
> > Not sure what you're aming for here and how your data is structured but
> > why not use a join and alias and fetch all info in one select and then
> > solve what you need in your code?
> >
> > Something in
Song Ken Vern-E11804 wrote:
> Hi,
>
> I'm trying to build a query in using SQL instead of doing it in Perl.
>
> I am trying to do something like this :
>
> If ((select col1 from table1 where id = 1) == 3)
> Then
> Select col2 from table2 where table2.id = 1;
> Else
> Select col2 from table3 where
is. Examples only show numeric and string functions.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 4:43 PM
To: [EMAIL PROTECTED]; Song Ken Vern-E11804
Cc: mysql@lists.mysql.com
Subject: RE: if else statement
SELECT IF(col1=3, (Select col2 f
Cc: mysql@lists.mysql.com
Subject: Re: if else statement
Not sure what you're aming for here and how your data is structured but
why not use a join and alias and fetch all info in one select and then
solve what you need in your code?
Something in the line of:
select t2.col2 from_t2, t3
Not sure what you're aming for here and how your data is structured but
why not use a join and alias and fetch all info in one select and then
solve what you need in your code?
Something in the line of:
select t2.col2 from_t2, t3.col2 from_t3
from table1 t1, table2 t2, table3 t3
where t1.id = t
On Wednesday 21 June 2006 11:16, Song Ken Vern-E11804 wrote:
> Hi,
>
> I'm trying to build a query in using SQL instead of doing it in Perl.
>
> I am trying to do something like this :
>
> If ((select col1 from table1 where id = 1) == 3)
> Then
> Select col2 from table2 where table2.id = 1;
> Else
rver 10.2, so if the suggestion you gave me is the
only way (or the best) I will have to upgrade the server. If there is
another way to do the same thing, please let me know.
Mike
> From: Egor Egorov <[EMAIL PROTECTED]>
> Date: Mon, 26 Jan 2004 15:40:54 +0200
> To: [EMAIL PROTE
Mike Tuller <[EMAIL PROTECTED]> wrote:
> I am trying write a shell script to check to see if a record exists and if
> it does, update information, and if it doesn't insert information. Is there
> a way to do an if else statement in MySql?
>
If you have PRIMARY KEY or UNIQUE index, take a look at
