FW: MySQL export and import into Oracle

------=_NextPart_000_0025_01CA906E.16E020F0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi guys,



Can you please assist me in rewriting this query in order to run this
against a mysql database?



It seems that the decode function does not exist in mysql.



select

decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr,

count(*) tot

from profiles

where email is not null

group by (decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No'))








------=_NextPart_000_0025_01CA906E.16E020F0--

Re: FW: MySQL export and import into Oracle

--00504502ae023f174f047ca7ea42
Content-Type: text/plain; charset=ISO-8859-1

http://dev.mysql.com/doc/refman/5.0/en/control-flow-function s.html#function_if

On Fri, Jan 8, 2010 at 5:52 PM, machiel.richards > wrote:

> Hi guys,
>
>
>
> Can you please assist me in rewriting this query in order to run this
> against a mysql database?
>
>
>
> It seems that the decode function does not exist in mysql.
>
>
>
> select
>
> decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr,
>
> count(*) tot
>
> from profiles
>
> where email is not null
>
> group by (decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No'))
>
>
>
>
>
>
>
>


--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--00504502ae023f174f047ca7ea42--

RE: FW: MySQL export and import into Oracle

------=_NextPart_000_0058_01CA9081.10E3DCB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Thank you for the link but seeing that I am still new with MySQL , this does
not mean anything to me.



From: prabhat kumar [mailto:aim.prabhat@gmail.com]
Sent: 08 January 2010 4:22 PM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: FW: MySQL export and import into Oracle



http://dev.mysql.com/doc/refman/5.0/en/control-flow-function s.html#function_
if

On Fri, Jan 8, 2010 at 5:52 PM, machiel.richards
wrote:

Hi guys,



Can you please assist me in rewriting this query in order to run this
against a mysql database?



It seems that the decode function does not exist in mysql.



select

decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr,

count(*) tot

from profiles

where email is not null

group by (decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No'))











--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat


------=_NextPart_000_0058_01CA9081.10E3DCB0--