Sql

Search

mysql cast null to string


#If you really must output every values including the NULL ones
select IFNULL(prereq,"") from test

#OR, Coalesce will return the first non-null argument passed to it
#from left to right. If all arguemnts are null, it'll return null, but we're forcing an empty string there, so no null values will be returned.
SELECT COALESCE(prereq, '') FROM test

Comment

PREVIOUS	NEXT

Code Example
Sql :: date format mysql
Sql :: sql counter column
Sql :: postgresql contains
Sql :: mssql check if date is greater than today
Sql :: postgresql Create a new role with a username and password
Sql :: python mysql query where
Sql :: adding constraints to columns SQL
Sql :: json extract
Sql :: oracle drop sequence if exists
Sql :: sqlalchemy update row
Sql :: install postgresql 10 centos 7
Sql :: pyspark sql row get value
Sql :: sql extract from mail
Sql :: delete a temporary table mysql
Sql :: inner join distinct
Sql :: ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides
Sql :: mysql to uppercase
Sql :: mysql count multiple columns in one query
Sql :: query by column for substring sql
Sql :: mysql 8 geo to json
Sql :: insert into select mysql
Sql :: mysql function variable
Sql :: sub query in linq
Sql :: select random sample sql
Sql :: t_sql contains
Sql :: insert in to table sql
Sql :: mysql how to use FIND_IN_SET function in WHERE clause ?
Sql :: Get all index postgres
Sql :: sql create table with data
Sql :: t-sql check if data exists

Search

SQL

mysql cast null to string

ADD CONTENT