Concatenate string with NULL value : Null : Data Type SQL / MySQL

SQL / MySQL » Data Type » Null »

Concatenate string with NULL value



/*
mysql> select CONCAT("a",null);
+------------------+
| CONCAT("a",null) |
+------------------+
| NULL             |
+------------------+
1 row in set (0.00 sec)


*/  
select CONCAT("a",null);

Related Scripts with Example Source Code in same category :

Retrieve NULL value
Working with NULL Values
Use the IS NULL and IS NOT NULL operators
NULL means 'not having a value'
Disallowing NULLs
Retrieve NOT NULL value
List NOT NULL value and order it
Select NOT NULL value
IS NOT NULL in where clause
NULL value in where clause
Read NULL value
Dealing With NULL Data

SQL / MySQL

Data Type
» Null

Backup Load

Command MySQL

Cursor

Data Type

Database

Date Time

Flow Control

Function

Insert Delete Update

Join

Key

Math

String

Trigger

View

Concatenate string with NULL value : Null : Data Type SQL / MySQL

SQL / MySQL » Data Type » Null »

Concatenate string with NULL value

Leave a Comment / Note

SQL / MySQL