SELECT * from book;
how to convert NULL result to 0 from the sql ?
+5
A:
SELECT IFNULL(pages, 0) FROM book;
if pages was the name of your column.
Peter Lang
2010-01-07 14:27:21
Probably not incredibly important in most cases, but seems worth noting that Coalesce is part of the SQL Standard and IfNull is not. If portability is a concern, Coalesce is the way to go
AlexCuse
2010-01-07 14:42:54
I like ifnull. coalesce sounds too pretentious.
Yada
2010-01-07 20:00:04
+7
A:
You're looking for the COALESCE keyword:
SELECT COALESCE(fieldName, 0) FROM book
Danny T.
2010-01-07 14:29:56
@nuclearmaker: No, you have to do that for all relevant columns. Something like `SELECT COALESCE(field1, 0), COALESCE(field2, 0) FROM book;`
Peter Lang
2010-01-07 14:43:23
You should never use `*` in practice, you should always list the fields you want to get.
MitMaro
2010-01-07 14:43:46