MySQL string addition function Concat ()

In MySQL, you cannot use the + operator to connect strings. To useConcat ()Function.
For example:
Update cdb_ex_site set viewlog = Concat (viewlog, 'HTTP: // www.cnblogs.com/qiantuwuliang /')
The preceding statement is the string http://www.cnblogs.com/qiantuwuliang/after the value of the viewlog field is granted to the field viewlog.

 

========================================================== ==============

 

ColumnThe plus sign (+) cannot be used for 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 processed as a string