1.带条件的update语句：
UPDATE tb_cloud_member t SET t.add_time =CONCAT(t.add_time,'-01') WHERE CHAR_LENGTH(t.add_time)<=7 and CHAR_LENGTH(t.add_time)>0; UPDATE tb_cloud_member t SET t.birth_date =CONCAT(t.birth_date,'-01') WHERE CHAR_LENGTH(t.birth_date)<=7 and CHAR_LENGTH(t.birth_date)>0;2.带replace函数
update kcloud_component set api_url = replace(api_url,'http://ftu.yangqgh.org.cn','http://127.0.0.1');