--这里是视频的所属直播设置为null
update pub_video set applicationguid = null where not exists(select * from pub_application where 
pub_video.applicationguid = pub_application.guid) and applicationguid is not null

--这里是删除不正确的直播点评数据
delete from pub_videotimeinfoother where not exists(select * from pub_user where pub_videotimeinfoother.userguid = pub_user.guid)
and userguid is not null