/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

2 votes331 views1 answer
Sql find not in list
SQL
0 vote325 views1 answer
Create table using the clause with as
SQL
0 vote299 views1 answer
Mysql insert into select transaction c#
SQL
-1 vote306 views1 answer
Minus vs except in sql
SQL
3 votes307 views1 answer
APEX elapsed time
SQL
1 vote294 views1 answer
Postgres cast as currency format
SQL
12 votes317 views6 answers
Distinct in sql server
SQL
0 vote329 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote299 views1 answer
Mysql multiple group by
SQL
4 votes276 views3 answers
Create database in mySQL
SQL

Share