List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:April 24 2006 11:25am
Subject:Re: problem with coalesce function
View as plain text  
Hello Pedro,

>MySQL version is 5.0.19. Runs in Win. XP pack 2. I put sql in command line
and i
> try using jdbc.
>The code:
>SELECT mfn,COALESCE (user_id,0)
>      FROM hits WHERE mfn =1;

Although it sounds silly, remove the space between COALESCE and the "("

That should do the trick.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
problem with coalesce functionpedroverissimo24 Apr
  • Re: problem with coalesce functionMartijn Tonies24 Apr
  • RE: problem with coalesce functionSST - Adelaide)24 Apr
    • RE: problem with coalesce functionPedro Verissimo24 Apr
    • Re: problem with coalesce functionMartijn Tonies24 Apr