/SQL/Mysql where value is null

Mysql where value is null

Mysql where value is null

SELECT *
FROM contacts
WHERE last_name IS NULL;

9

Check if value is null mysql

SELECT * from TABLE where CODE IS NULL OR CODE!='C'

4

Source: stackoverflow.com

Mysql set value as null

UPDATE table SET field = NULL WHERE something = something

2

Source: stackoverflow.com

If column value is null then in mysql

 SELECT 
    contactname, IFNULL(bizphone, homephone) phone
FROM
    contacts;

0

Source: mysqltutorial.org

Similar codes

0 vote315 views1 answer
Sql include rows with 0 values
SQL
0 vote319 views1 answer
Create dump file mysql workbench
SQL
9 votes341 views2 answers
SELECT User,Host FROM mysql.user;
SQL
2 votes322 views1 answer
Column names in oracle sql
SQL
0 vote304 views1 answer
Json not contains mysql
SQL
0 vote304 views2 answers
Sql drop view if exists
SQL
0 vote312 views1 answer
Reset keys in sql
SQL
0 vote302 views1 answer
Mysql money value
SQL
1 vote316 views2 answers
How to search date in sql query
SQL
17 votes315 views3 answers
Postgresql version command
SQL

Share