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

 #移动数据
 UPDATE dcs_organize_user AS a, dcs_organize_user AS b SET a.SHORTTELNO=b.USERTELNO WHERE a.id=b.id;

 #字段加前缀
  UPDATE dcs_organize_user SET USERTELNO=CONCAT('0038089819',USERTELNO);

 

转载于:https://www.cnblogs.com/alamps/p/8081123.html