/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 vote225 views1 answer
Mysql cli output to a file
SQL
18 votes216 views6 answers
Creating table in MySQL
SQL
0 vote210 views1 answer
Basic structure of sql expression having clause
SQL
-1 vote211 views1 answer
Sql set max value in column
SQL
1 vote223 views1 answer
Round function in sql oracle
SQL
1 vote212 views1 answer
Find a column in all tables postgres
SQL
1 vote212 views1 answer
Sql order by timestamp
SQL
4 votes212 views2 answers
Postgres update single column
SQL
0 vote209 views1 answer
Sqlite version check
SQL
1 vote219 views1 answer
Delete from inner join sql
SQL

Share