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

mysql sql修改语句 在指定字段前面加上字符串

update ct_addrbzw set des=concat("平遥",des)

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

 

update ct_meteraddr cm
LEFT JOIN ct_addrbzw ca on ca.id = cm.bzw_id
set cm.addr_room_des1=concat(ca.des,cm.addr_room_des1)

 

sql语法这样写。

例子

mysql> UPDATE v95_soft a
 RIGHT JOIN dp_softlist b ON a.id = b.softid
 SET a.catid = b.softclassid;
 
 mysql> UPDATE v95_soft set url = CONCAT(url,id);
 
 mysql> UPDATE v95_soft set url = CONCAT(url,catid);
 
 mysql> UPDATE v95_(www.111cn.net)soft a
 RIGHT JOIN dp_softlist b ON a.id = b.softid
 SET a.start = b.softscore;
 
 mysql> UPDATE v95_soft a
 RIGHT JOIN dp_softlist b ON a.id = b.softid
 SET a.updatetime = UNIX_TIMESTAMP(b.softcreatedate);
 
 mysql> update v95_soft set sysadd=1;

 

 

UPDATE file_manager_folder f1
 LEFT OUTER JOIN file_manager_folder f2
     ON f1.name = f2.(www.111cn.net)name AND f2.parentId = 54
 SET f1.parentId = 54
 WHERE f2.name IS NULL AND f1.id IN (1,2,3);