/SQL/If 0 return null else return query mysql

If 0 return null else return query mysql

Mysql return 0 if null

SELECT IFNULL(field, 0) AS field FROM products WHERE id = 1

SELECT IFNULL(SUM(field), 0) as field FROM products

3

Source: grepper.com

Similar codes

0 vote168 views1 answer
Sql_inner_join
SQL
0 vote177 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote200 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
2 votes174 views1 answer
How to delete view in sql
SQL
2 votes168 views1 answer
Sql create database
SQL
2 votes187 views1 answer
Oracle block
SQL
2 votes175 views1 answer
Oracle list grants on package
SQL
0 vote224 views1 answer
Sql query for login with email or username
SQL
0 vote174 views1 answer
Sql server size of every table in a db
SQL
0 vote177 views1 answer
Apex for oracle 11g
SQL

Share