Re: dyna query problem
Of course, you should fix it. Use COALESCE or IF() function to change NULL with another value, e.g. -
SET @var = NULL;
SELECT COALESCE(@var, 'Hello world!'); --> will output 'Hello world!'
Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/
Subject
Views
Written By
Posted
2543
August 06, 2012 12:53AM
971
August 08, 2012 03:56AM
804
August 09, 2012 12:39AM
Re: dyna query problem
975
August 09, 2012 02:22AM
836
August 09, 2012 02:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.