Sql

Search

mysql concatenate null

SELECT
    CONCAT(
        IFNULL(`affiliate_name`, ''),
        '-',
        IFNULL(`model`, ''),
        '-',
        IFNULL(`ip`, ''),
        '-',
        IFNULL(`os_type`, ''),
        '-',
        IFNULL(`os_version`, '')
    ) AS device_name
FROM
    devices

Comment

PREVIOUS	NEXT

Code Example
Sql :: CONCAT_WS() concat function in mysql
Sql :: sql select sum group by id laravel
Sql :: get primary key of table
Sql :: create or replace table sql
Sql :: sqlite woth cmake
Sql :: mysql select multiple rows into one column
Sql :: mysql select tables with name like
Sql :: add primary key with auto increment sql server
Sql :: oracle insert into
Sql :: search for replace in mysql
Sql :: set id count mysql
Sql :: drop df constraint sql server
Sql :: sql compare two tables for differences
Sql :: mysql delete all except
Sql :: create table in microsoft sql server
Sql :: describe table postgres
Sql :: oracle timestamp to date
Sql :: select into temp table
Sql :: join in update query in mysql
Sql :: SQL Auto Increment Primary Key - PostgreSQL
Sql :: mysql terminal run sql file
Sql :: sql current date
Sql :: oracle running queries
Sql :: alter table name sql
Sql :: install mysql on ubuntu
Sql :: postgres extract day from date
Sql :: sql count null as 0
Sql :: how to check if a column is null in sql
Sql :: how to enable mysql 5.7 root user password on linux
Sql :: postgresql get connection string

Search

SQL

mysql concatenate null

ADD CONTENT