/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

3 votes171 views1 answer
What is having
SQL
0 vote180 views1 answer
Select count concat string sql server
SQL
0 vote97 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
8 votes208 views2 answers
Oracle auto increment primary key
SQL
0 vote154 views1 answer
Oracle query to find schema you are working on
SQL
1 vote156 views2 answers
Mysql update table from another table
SQL
0 vote147 views1 answer
Sql get number of days between two dates
SQL
2 votes146 views1 answer
Postgresql add entry to table
SQL
0 vote155 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote142 views1 answer
Mariadb number format
SQL

Share