MySQL: Typecasting NULL to 0

by

Use IFNULL(column, 0) to convert the column value to zero.

Alternatively, the COALESCE function will do the same thing: COALESCE(column, 0), except

  1. COALESCE is ANSI-compliant, IFNULL is not
  2. COALESCE takes an arbitrary number of columns/values and will return the first non-null value passed to it.

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Delete from two tables in one query
  3. Why would an IN condition be slower than “=” in sql?
  4. PostgreSQL GROUP BY different from MySQL?
  5. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  6. Fulltext Search with InnoDB
  7. MySQL’s now() +1 day
  8. Delete sql rows where IDs do not have a match from another table
  9. Rewriting mysql select to reduce time and writing tmp to disk
  10. How do I convert from BLOB to TEXT in MySQL?
  11. Can you access the auto increment value in MySQL within one statement?
  12. Which SQL query is better, MATCH AGAINST or LIKE?
  13. What does DELIMITER // do in a Trigger?
  14. MySQL equivalent of DECODE function in Oracle
  15. Mysql: how to select groups having certain values?
  16. How to create a multi-tenant database with shared table structures?
  17. Discard millisecond part from timestamp
  18. MySQL #1140 – Mixing of GROUP columns
  19. MySQL: GROUP_CONCAT with LEFT JOIN
  20. Boolean vs tinyint(1) for boolean values in MySQL
  21. How to convert PostgreSQL 9.4’s jsonb type to float
  22. Find rows that have the same value on a column in MySQL
  23. How to change string date to MySQL date format at time of import of CSV using MySQL’s LOAD DATA LOCAL INFILE
  24. What does collation mean?
  25. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  26. sql pulling a row for next or previous row of a current row
  27. Row Rank in a MySQL View
  28. Select Rows with Maximum Column Value group by Another Column
  29. converting int to real in sqlite
  30. mysql GROUP_CONCAT duplicates

Leave a Comment