摘要：CREATE TRIGGER https://www.sqlite.org/lang_createtrigger.html 触发器 DROP TABLE IF EXISTS user_token;CREATE TABLE IF NOT EXISTS user_token (id INTEGER NO 阅读全文

摘要：device_id event_time device_status 开 开 关 关 开 关 最近一次开机的时刻 SELECT MIN(ts0),device_id FROM ( SELECT t0.event_time AS ts0,t0.device_id ,ts1 FROM tab as t0 阅读全文

摘要：-- 文章表、用户行为表（文章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 阅读全文