/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

1 vote137 views1 answer
Sql count value greater than
SQL
0 vote152 views1 answer
Implode in sql query
SQL
0 vote127 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote133 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote139 views1 answer
Postgresql auto increment not working
SQL
13 votes149 views2 answers
Sqlite rename table
SQL
44 votes206 views6 answers
Rename command in sql
SQL
4 votes135 views1 answer
Wilayah indonesia database
SQL
0 vote115 views1 answer
How to create an SQL save method in ruby
SQL
0 vote138 views1 answer
Mysqldump don't drop table
SQL

Share