/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 vote191 views3 answers
Joins and views sql
SQL
7 votes316 views2 answers
Drop index oracle
SQL
24 votes195 views5 answers
Sql server insert into select
SQL
1 vote203 views1 answer
Find a column in all tables postgres
SQL
0 vote148 views1 answer
How to fetch highest score in minimum time using mysql
SQL
9 votes256 views3 answers
Postgres make sql dump
SQL
3 votes215 views2 answers
How to delete git repo locally
SQL
1 vote199 views1 answer
Sql server datetime vs datetime2
SQL
1 vote226 views1 answer
Mysql select and count left join
SQL
8 votes197 views1 answer
Oracle create datafile
SQL

Share