先查再改，为什么会丢
「包进事务里不就行了」——事务到底挡住了什么？
Copy the prompt, then pick a model. It plays the interviewer and asks you through it scene by scene instead of handing you the answer.
On a phone with the app installed, the system opens the app directly. Links cannot open external apps inside WeChat — open it in a browser first.
The copied text ends with the answer key the model grades you against. Don't read it yourself first — working it out on your own is the point.
这是所有并发 bug 里最常见的一种形状：读出来、判断一下、再写回去。而「加个事务」几乎不解决它 —— 两个事务照样能分别读到 stock = 1。
这一份要你自己画出那条让库存变成 -1 的时间线，然后一步步收窄：把判断挪进 WHERE、看受影响行数、什么时候该用版本号、什么时候该交给唯一约束。
有一问值得先想想：「打开编辑器就锁住、保存时才放」为什么在 Web 上几乎一定是错的。
What this one drills
This prompt in the repo (the answer key is at the end of that file — you'll see it)
Have you done this one?
Sign in to mark this one as practised — next time you come back you'll see when you did it.
Notes from people who did this one
How to use this
These are learning drills: the model guides, it does not corner you. When you get stuck it first asks which layer you are stuck at (never heard of it / know it but not why / know why but cannot apply it), then decides what to give. It only explains after guiding twice, and then asks you to say it back in your own words.
It assumes MySQL / InnoDB by default — half the traps here are implementation details, and clustered indexes, back-to-the-table lookups and gap locks work differently elsewhere. PostgreSQL or anything else is fine: say so in your first message and it will follow your engine, calling out where the conclusions differ.
How to start
- Pick one, open it, copy the prompt.
- Paste it into a fresh, empty chat, and say which engine and version you use first (say nothing and it assumes MySQL 8).
- Then say nothing else and wait for its first question.
Four commands you can call out any time
跳过Move on to the next scene换个说法Explain this bit from another angle直说吧Give the full answer, then make me say it back复盘Jump straight to the wrap-up card
Three traps
- Do not read the answer key at the end first — the "what people get wrong" section is the answer to every question in the drill.
- Expect to be pushed for numbers. "A bit faster", "saves IO" gets cut off on the spot: how many rows? how many times? how many times faster? A conclusion with no number behind it is memorised.
- The moment it starts praising you, point it back at the "do not praise me" rule. Guiding is not coddling.
Start with the composite index one — it is the foundation here; "locks sit on index records" and "why is it scanning so many rows" both lean on its one-line model. If concurrency is biting you in production, start with read-modify-write instead; if queries are slow, start with the execution plan one.
Sign in to write a note.