Replace null with 0 in MySQL

by

Yes, by using COALESCE.

SELECT COALESCE(null_column, 0) AS null_column FROM whatever;

COALESCE goes through the list of values you give it, and returns the first non-null value.

More Related Contents:

  1. MySQL comparison with null value
  2. MySQL CONCAT returns NULL if any field contain NULL
  3. Why in SQL NULL can’t match with NULL?
  4. get first occurrence of last changed value of a column [closed]
  5. INSERT INTO SELECT statement with more columns which is not in another table
  6. multiple query same table but in different columns mysql
  7. How can I make SQL case sensitive string comparison on MySQL?
  8. 1052: Column ‘id’ in field list is ambiguous
  9. How to do a batch insert in MySQL
  10. Count the occurrences of DISTINCT values
  11. Creating a “Numbers Table” in MySQL
  12. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  13. Cumulative sum over a set of rows in mysql
  14. Set NOW() as Default Value for datetime datatype?
  15. Add Auto-Increment ID to existing table?
  16. MySQL SELECT DISTINCT multiple columns
  17. SQL DELETE with JOIN another table for WHERE condition
  18. mysql trigger stored trigger is already used by statement which invoked stored trigger
  19. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  20. Using group by on two fields and count in SQL
  21. Can MySQL convert a stored UTC time to local timezone?
  22. mysql update query with sub query
  23. What is the difference between the backtick and the square bracket in SQL statements?
  24. Integrity constraint violation: 1452 Cannot add or update a child row:
  25. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  26. How to insert a file in MySQL database?
  27. What does SQL Select symbol || mean?
  28. SQL query with avg and group by
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment