1:联合表修改字段属性
2:GROUP_CONCAT 函数是将自定义字符拼接(避免查出结果为 BLOB 类型)
UPDATE program_info p2 LEFT JOIN
(select p.program_id ,GROUP_CONCAT(cast(t.name as char)) tag from tag_info t RIGHT JOIN program_tag_map p ON t.id=p.tag_id WHERE t.del_flag=0 AND p.del_flag=0 GROUP BY p.program_id) t2
ON p2.id=t2.program_id
SET p2.tags = t2.tag
追加联合修改sql(含替换):
示例:Update `table_name` SET `field_name` = replace (`field_name`,’from_str’,'to_str’);
说明:
table_name —— 表的名字
field_name —— 字段名
from_str —— 需要替换的字符串
to_str —— 替换成的字符串
实战(注意修改的字段和替换的字段先后顺序(先替换在修改)):
Update physical_channel p LEFT JOIN t_u_physical_channel pc ON
p.channel_id=pc.TV_ID
SET p.play_url= replace (p.play_url,p.physical_content_id,pc.PHYSICAL_CONTENT_ID) ,
p.physical_content_id=pc.PHYSICAL_CONTENT_ID
Where p.channel_id=30