坑爹蛋疼的SQL（大学不好好学，招报应了）

最新推荐文章于 2024-04-09 09:38:05 发布

weixin_30919429

最新推荐文章于 2024-04-09 09:38:05 发布

阅读量171

点赞数

原文链接：http://www.cnblogs.com/homerzhm/archive/2013/01/14/2859130.html

版权

SQL 随笔，以后再整理

update dsong set ratesp = (select 1.0*skiptime/playtime from song where song.filename=dsong.songname) where dsong.songname = (select filename from song where song.filename = dsong.songname)

update dsong set maxpcontinue = (SELECT max(pcontinue) FROM skipinfor where skipinfor.filename = dsong.songname) where dsong.songname = (select filename from skipinfor where skipinfor.filename = dsong.songname)

update dsong set maxscontinue = (SELECT max(scontinue) FROM skipinfor where skipinfor.filename = dsong.songname) where dsong.songname = (select filename from skipinfor where skipinfor.filename = dsong.songname)

update dsong set firstpicktimes = (select count(*) from firstpick where firstpick.filename = dsong.songname) where dsong.songname = (select filename from firstpick where firstpick.filename = dsong.songname)

转载于:https://www.cnblogs.com/homerzhm/archive/2013/01/14/2859130.html