Instance method for mysql string concatenation and setting null value

Instance method for mysql string concatenation and setting null value

#String concatenation concat(s1,s2); concatenate the strings in last_name and first_name in the table

select concat(last_name,first_name) as name from employees;

#Only last_name will be modified, not first_name

SELECT first_name,last_name AS f FROM employees;

# Separate the two columns with a comma and name them out_put

SELECT CONCAT(`last_name`,',',`phone_number`) AS out_put FROM employees;

#ifnull determines whether it is empty. If it is empty, it will be displayed as 0 instead of null, and the column name will be displayed as the result

SELECT IFNULL(commission_pct,0) AS result FROM employees;

Content extension:

String concatenation

1.1 The CONCAT(s1, s2, ...) function returns the string generated by concatenating the parameters, one or more contents to be concatenated. If any one of them is NULL, the return value is NULL.

SELECT CONCAT('Current time:',NOW()); -- Output result: Current time: 2019-01-17 11:27:58


1.2 CONCAT_WS(x,s1,s2,...) function

Returns a string consisting of multiple strings concatenated together, with an x ​​between each string.

SELECT CONCAT_WS(';','pan_junbiao's blog','KevinPan','pan_junbiao'); -- Output: pan_junbiao's blog;KevinPan;pan_junbiao

I hope the above content can help everyone. Thank you for your support of 123WORDPRESS.COM.

You may also be interested in:
  • Tutorial on understanding and using NULL values ​​in MySQL
  • Detailed explanation of NULL values ​​in MySQL
  • Mysql implements null value first/last method example
  • Distinguish between null value and empty character ('''') in MySQL
  • MySQL NULL value processing example detailed explanation
  • Do you know the difference between empty value and null value in mysql
  • This article takes you to explore NULL in MySQL

<<:  Vue component encapsulates sample code for uploading pictures and videos

>>:  How to build a K8S cluster and install docker under Hyper-V

Recommend

MySQL 5.7.20 compressed version download and installation simple tutorial

1. Download address: http://dev.mysql.com/downloa...

Detailed explanation of Nginx's rewrite module

The rewrite module is the ngx_http_rewrite_module...

CSS3 creates web animation to achieve bouncing ball effect

Basic preparation For this implementation, we nee...

Nginx forwarding based on URL parameters

Use scenarios: The jump path needs to be dynamica...

Implementation principle and configuration of MySql master-slave replication

Database read-write separation is an essential an...

MySQL advanced learning index advantages and disadvantages and rules of use

1. Advantages and Disadvantages of Indexes Advant...

jQuery implements simple pop-up window effect

This article shares the specific code of jQuery t...

Nginx configuration location matching rules example explanation

The scope of nginx configuration instructions can...

How to change the database data storage directory in MySQL

Preface The default database file of the MySQL da...

CentOS7 64-bit installation mysql graphic tutorial

Prerequisites for installing MySQL: Install CentO...

A brief discussion on read-only and disabled attributes in forms

Read-only and disabled attributes in forms 1. Rea...

Vue calculated property implementation transcript

This article shares the Vue calculation property ...

Steps to configure nginx ssl to implement https access (suitable for novices)

Preface After deploying the server, I visited my ...

How to add, delete and modify columns in MySQL database

This article uses an example to describe how to a...