在MySQL和SQL Server中，通过update语句调整VideoFrequency表的resourceUrl字段，确保URL的有效性，特别关注长度小于1的情况。
mysql 下:
update VideoFrequency , VideoFrequencyLibrary
set VideoFrequency. resourceUrl = VideoFrequencyLibrary.Url
where
VideoFrequency.id = VideoFrequencyLibrary.videoId
and
length(resourceUrl) < 1
sqlserver下:
update VideoFrequency
set VideoFrequency. resourceUrl = VideoFrequencyLibrary.Url
from VideoFrequency, VideoFrequencyLibrary
where
VideoFrequency.id = VideoFrequencyLibrary.videoId
and
length(resourceUrl) < 1
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
