How does the MySQL string addition function run? I'm a stranger. Remember it.

Label: MySQL string

The following Article describes the actual operation scheme of the MySQL string addition function, we all know that in MySQL databases, the + operator cannot be used to actually connect MySQL strings. The Concat () function is required.

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 appended.

the column cannot be directly added with the plus sign (+) ), the Concat function needs to be referenced.

example: Concat (string, Concat (column name, string ))

the preceding example contains two additions.

the string + string can be directly added to a common string.

MySQL the date type can be treated as a MySQL string

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