msyql移动某一列数据到某列字段加前缀

#移动数据UPDATE dcs_organize_user AS a, dcs_organize_user AS b SET a.SHORTTELNO&＃61;b.USERTELNO WHERE a.id&＃61;b.id;#字段加前缀UPDATE dcs_organize_user SET USERTELNO&＃61;CONCAT(&＃39;0038089819&＃39;,USERTELNO);