/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 vote145 views1 answer
Sql datediff month
SQL
0 vote171 views1 answer
MySQL get all previous date record
SQL
3 votes144 views2 answers
Mysql config user password
SQL
0 vote142 views1 answer
To change the database owner in SQL server
SQL
41 votes222 views6 answers
Alter table add column in SQL Server
SQL
0 vote100 views1 answer
Bigquery information_schema schema all columns
SQL
1 vote230 views1 answer
Primary key reset in SQL database
SQL
0 vote162 views1 answer
View to table sql
SQL
0 vote144 views1 answer
Add alternate add column sql
SQL
0 vote186 views1 answer
Oracle sqlp update amount / quantity
SQL

Share