/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

1 vote129 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote131 views3 answers
Postgresql allow remote connections
SQL
0 vote88 views1 answer
Finish transaction sql
SQL
0 vote283 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote122 views4 answers
Sql year
SQL
2 votes133 views1 answer
Where clause for child record apex
SQL
0 vote144 views1 answer
Mysql persistence.xml
SQL
0 vote125 views1 answer
How to open mysql in docker
SQL
5 votes114 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote130 views1 answer
Mysql date time string format python
SQL

Share