/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 vote177 views1 answer
Select * where id = 1,2,3
SQL
0 vote170 views1 answer
Oracle select partition
SQL
0 vote180 views1 answer
Is not numeric sql
SQL
0 vote184 views1 answer
Create function in microsoft sql server
SQL
0 vote178 views1 answer
Change date format in oracle query
SQL
12 votes177 views2 answers
Delete entries in postgresql
SQL
14 votes188 views3 answers
How to add default constraint in mysql
SQL
0 vote224 views2 answers
Insert data into multiple tables mysql
SQL
20 votes192 views3 answers
Update values in select statement sql
SQL
0 vote180 views1 answer
Sql delete from with relation
SQL

Share