mysql null to 0
mysql, sql
Solution
You're looking for the COALESCE keyword:
SELECT COALESCE(fieldName, 0) FROM book
Problem
``` SELECT * from book; ``` how to convert NULL result to 0 from the sql ?
mysql, sql
You're looking for the COALESCE keyword:
SELECT COALESCE(fieldName, 0) FROM book
``` SELECT * from book; ``` how to convert NULL result to 0 from the sql ?