摘要: Element.outerHTML - Web APIs | MDN https://developer.mozilla.org/en-US/docs/Web/API/Element/outerHTML DOM Parsing and Serialization https://w3c.github 阅读全文
posted @ 2021-05-07 14:55 papering 阅读(46) 评论(0) 推荐(0) 编辑
摘要: 中介者模式 | 菜鸟教程 https://www.runoob.com/design-pattern/mediator-pattern.html 中介者模式 中介者模式(Mediator Pattern)是用来降低多个对象和类之间的通信复杂性。这种模式提供了一个中介类,该类通常处理不同类之间的通信, 阅读全文
posted @ 2021-05-07 13:44 papering 阅读(114) 评论(0) 推荐(0) 编辑
摘要: -- 文章表、用户行为表(文章Id-Uid-行为类型) SELECT t0.Id,t1.n AS FavouriteNum, t2.n AS LikeNum FROM article AS t0LEFT JOIN ( SELECT COUNT(1) AS n,ArticleId FROM artic 阅读全文
posted @ 2021-05-07 11:54 papering 阅读(98) 评论(0) 推荐(0) 编辑
摘要: MySQL :: MySQL 8.4 Reference Manual :: 15.2.13.2 JOIN Clause https://dev.mysql.com/doc/refman/8.4/en/join.html MySQL LEFT JOIN Keyword https://www.w3s 阅读全文
posted @ 2021-05-07 11:10 papering 阅读(59) 评论(0) 推荐(0) 编辑