例如表
业务需求:将code的值设置为A+id的值
mysql命令:update permit_list setcode= concat('A',id) (更新字段信息: UPDATE permit_list SET OWNER= "admin;myself" WHERE CODE = "A0000")
update permit_list set
= concat('A',id)
UPDATE permit_list SET OWNER= "admin;myself" WHERE CODE = "A0000"
UPDATE user SET address = concat(latitude,”,”,longitude)
user