MySQL Forums
Forum List  »  Newbie

Re: is it possible outfile without null fields?
Posted by: Diego Medina
Date: February 20, 2009 09:50AM

Hi Sharla,

One option could be to write your query like this:

SELECT ifnull(col1,""), ifnull(col2,"") FROM table_name
WHERE col1> 100;

Please read for more information on the function ifnull


Diego Medina, QA Engineer
Enterprise Tools - Database Group, Sun Microsystems

Are you MySQL certified?

Options: ReplyQuote

Written By
Re: is it possible outfile without null fields?
February 20, 2009 09:50AM

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.