Re: is it possible outfile without null fields?

[Diego Medina]

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 http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ifnull for more information on the function ifnull

Regards,

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

Are you MySQL certified? http://www.mysql.com/certification