Jochen's recent timeline updates
Jochen

Jochen

V2EX member #189629, joined on 2016-08-31 17:05:21 +08:00
Today's activity rank 24265
Jochen's recent replies
Mar 3, 2025
Replied to a topic by momomoi MacBook 买了个 14 寸 m4pro 48+512
@momomoi #3 这个价格是怎么买到的?我最近也在看这个配置,发现定制款不能走国补
支持以下楼主
已购买,支持一下
感谢楼主的分享!
iina 好用,支持楼主!
@DavidNineRoc 查询结果为空是因为 top_at 字段的值可以为 null,而在 MySQL 中,NULL 值与任何其它值的比较(即使是 NULL )永远返回 NULL,即 NULL = NULL 返回 NULL。

针对这种情况,可以稍微处理一下:
SET @id = 12345;
SELECT
*
FROM
articles
WHERE
IFNULL(top_at,1) > ( SELECT IFNULL(top_at,1) FROM articles WHERE id = @id )
OR (IFNULL(top_at,1) = ( SELECT IFNULL(top_at,1) FROM articles WHERE id = @id ) AND created_at >= (SELECT
created_at FROM articles WHERE id = @id))
AND id != @id
ORDER BY top_at ASC, created_at ASC
LIMIT 1;
找上一篇 SQL:
SET @id = 12345;
SELECT
*
FROM
article
WHERE
top_at > ( SELECT top_at FROM article WHERE id = @id )
OR (top_at = ( SELECT top_at FROM article WHERE id = @id ) AND created_at >= (SELECT created_at FROM article WHERE id = @id))
AND id != @id
ORDER BY top_at ASC, created_at ASC
LIMIT 1;

我在本地模拟了几条 SQL 是 OK 的。
Dec 13, 2019
Replied to a topic by koolob 北京 起诉自如后续,终于拿到判决书了
支持楼主
主页所有按钮和链接都点击不了,控制台报:Uncaught could not load memory initializer https://oyyd.github.io/wasm-opencc/opencc-asm.js.mem
本人 MAC Chrome 76.0.3809.132
About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1252 Online   Highest 6679   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 17ms · UTC 23:38 · PVG 07:38 · LAX 16:38 · JFK 19:38
♥ Do have faith in what you're doing.