Question

怎样在mysql中A表B字段开头增加C字符串？ 求sql语句

Answer 1

update A set A.B = 'C'||B
oracle中是这么写的，应该差不多，如果不对那就是：
update A set A.B = 'C'+B

Answer 2

update A
set B='C'+B

追问

[SQL] UPDATE kuyu_threads set subject = '新手训练营--' + subject WHERE type=496

[Err] 1292 - Truncated incorrect DOUBLE value: '新手训练营--'

追答

update A
set B=cast(('C'+cast(B as char) ) as char)

Answer 3

Update A set B= CONCAT(C,B)