/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 vote159 views1 answer
Sql last time database was accessed
SQL
150 votes329 views10 answers
Grepper
SQL
1 vote144 views1 answer
Multiple count in sql
SQL
44 votes255 views4 answers
Mysql alter table add column first
SQL
0 vote150 views1 answer
How to close external sql connection in laravel
SQL
0 vote126 views1 answer
Postgresql certain first 4 characters in string
SQL
13 votes138 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
2 votes100 views1 answer
Oracle current date without time
SQL
1 vote149 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote143 views1 answer
Selecting duplicates
SQL

Share