Search
 
SCRIPT & CODE EXAMPLE
 

SQL

if column value is null then in mysql

 SELECT 
    contactname, IFNULL(bizphone, homephone) phone
FROM
    contacts;
Comment

check if value is null mysql

SELECT * from TABLE where CODE IS NULL OR CODE!='C'
Comment

PREVIOUS NEXT
Code Example
Sql :: insert snowflake 
Sql :: sql replace single quote 
Sql :: firebase query timestamp 
Sql :: get all columns in a table sql 
Sql :: postgres top 10 
Sql :: select columns postgres 
Sql :: get max salary from each department sql 
Sql :: T-SQL - Delete Column 
Sql :: sql query rename table 
Sql :: sql cnvert bit to nvarchar 
Sql :: q operator in plsql 
Sql :: influxdb list all tags for a measurement 
Sql :: postgres week number 
Sql :: sql alter table order by 
Sql :: mysql function 
Sql :: install latest mysql 8 linux server 
Sql :: encrypt and decrypt in sql server 
Sql :: How to insert data in mysql ? 
Sql :: oracle change tablespace size 
Sql :: insert into auto increment mysql 
Sql :: show details of table postgres 
Sql :: change permission to database mysql 
Sql :: not regexp_like in oracle 
Sql :: mysql select latest entry by time 
Sql :: order by ip address sql 
Sql :: order by multiple columns 
Sql :: Write an SQL query to fetch worker names with salaries = 50000 and <= 100000. 
Sql :: oracle error compilation line 
Sql :: sql script to remove default from column 
Sql :: generate sql from specific migration ef core 
ADD CONTENT
Topic
Content
Source link
Name
4+7 =