The MySQL string addition function is a commonly used function. The following describes the actual operation scheme of the MySQL string addition function. If you are interested in the MySQL string addition function, take a look.
We all know that in MySQL databases, the + operator cannot be used to actually connect MySQL strings. 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 directly used 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 '.
The date type of MySQL can be treated as a MySQL string.
Problem about distinct in mysql query statements
How to Implement MySQL full-text Query
Example of the number of MySQL query results
Optimization of MySQL query Paging
MySQL query results are sorted by a certain value