数据库

SQL 基础

-- 查询
SELECT id, name, created_at FROM users WHERE active = 1 ORDER BY created_at DESC LIMIT 10;

-- 联表
SELECT u.name, p.title
FROM users u
JOIN posts p ON p.user_id = u.id;

-- 插入
INSERT INTO notes (title, content, user_id) VALUES ('标题', '内容', 1);

待补充

• [ ] 索引设计原则
• [ ] 事务与锁
• [ ] Redis 缓存策略