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 ;

posted @ 2018-05-14 14:22  ahuo  阅读(528)  评论(0编辑  收藏  举报