/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 vote332 views1 answer
Setval pgsql
SQL
0 vote307 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
14 votes335 views4 answers
Import database through command line
SQL
0 vote321 views1 answer
Regex any word except sql
SQL
0 vote307 views1 answer
Where case insensitive like mysql
SQL
0 vote291 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote287 views7 answers
10 random questions use python and SQL
SQL
4 votes299 views1 answer
Psql get sequences
SQL
0 vote327 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote300 views1 answer
How much table store postgres
SQL

Share