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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
