How does the MySQL string addition function run?

The following articles mainly introduce the actual operation scheme of the MySQL string addition function. We all know that the + operator cannot be used in the MySQL database for the actual connection of the MySQL string. The concat () function is required.

For example:

 
 


  
  
Update cdb_ex_site set viewlog = concat (viewlog, 'HTTP: // www.cnblogs.com/qiantuwuliang /')

 
 

The preceding statement is the MySQL string http://www.cnblogs.com/qiantuwuliang/after the value of the viewlog field is assigned to the field viewlog.

The plus sign + cannot be used directly for column addition. The concat function must be referenced,

Example: concat ('string', concat (column name, 'string '))

The preceding example contains two additions.

You can add 'string' and 'string' to a normal string'

MySQL date type can be treated as MySQL string

 

 

The above content is an introduction to the MySQL string addition function. I hope you will find some gains.