Why is MySQL returning Truncated incorrect DOUBLE value: '|546674311'?

Question

MySQL

There is the following query:
`UPDATE \`promo\` SET \`users_id\`=\`users_id\`+'|${mes.senderId}' WHERE \`code\` = '${promo.text}'`

` promo` - `users_id` table
- LONGTEXT column
`code` - TEXT column
mes.senderId = 546674311

Answer 1

Because |546674311 is not a valid real number for the mathematical operation of addition. If you wanted to merge strings rather than add, then there is the CONCAT () function for this.