The solution to the error of concatenation of string and num type in Mysql _mysql

Find problems

The picture address is as follows

Yun_qi_img/1473574486942944.jpg

The effect you need to implement is to add dimensions, such as the following effects

yun_qi_img/1473574486942944.jpg|1200*675

At first take for granted

UPDATE tag_group SET cover = cover + ' |1200*675 ' WHERE id = 1;

Result error

Data truncation:truncated Incorrect DOUBLE value: ' Yun_qi_img/1473574486942944.jpg '

The tip says that an incorrect value has been intercepted.

Solving method

Find out the data string stitching recommended by concat function stitching

UPDATE tag_group SET cover = concat (cover, ' |1200*675 ') WHERE id=1;

Summarize

The above is the entire content of this article, we have learned, in fact, the solution to this problem is very simple, I hope this article content for everyone's study or work can bring some help, if you have questions you can message exchange.