sql语句 update 字段=字段+字符串

update aa set name=concat('x',name)

SELECT OWNER,phone ,COUNT(fc_hc) as c from tb_p GROUP BY fc_hc HAVING c >1 ;

转载于:https://www.cnblogs.com/ahuo/p/9035884.html