Re: Dynamic SQL. Is it possible?

[Roland Bouman]

Although you can build SQL statements from strings with the prepared statement syntax (see: http://dev.mysql.com/doc/refman/5.0/en/sqlps.html) I advise not to. It's not that this syntax does not work (it works fine, exactly as described in the docs), it just isn't necessary to do it like this. Just do it like this:

UPDATE tablex
SET col1 = COALESCE(par1,col1)
, col2 = COALESCE(par2,col2)
, col3 = COALESCE(par3,col3)

COALESCE will evaluate to the first non-NULL argument value. see: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html



Edited 1 time(s). Last edit at 11/04/2005 08:56AM by Roland Bouman.