Why does this error occur during sql query?

Question

SQL

Hello!

I'm trying to add the word Europe to the end of each pagetitle column from the modx_site_content table .

My query is:

UPDATE modx_site_content SET pagetitle = pagetitle + '  Европа'
WHERE (template='4' AND published='1')

Mistake:

#1292 - Truncated incorrect DOUBLE value: 'Труба профильная 15*15*0,9 мм'

Answer 1

Because you are performing an arithmetic addition operation on text values.
To concatenate text strings, there is the CONCAT() function.