FAQ - MySQL

SQL Updated Sep 19, 2026

Dirty read, Lost of modify, Unrepeatable read, Phantom read

https://javaguide.cn/database/mysql/mysql-questions-01.html#并发事务带来了哪些问题

MySQL index

B+ tree as underline structure
https://javaguide.cn/database/mysql/mysql-index.html#索引介绍

MySQL `explain` (execution plan)

https://javaguide.cn/database/mysql/mysql-query-execution-plan.html#id

use `DateTime` or `TimeStamp` ?

https://javaguide.cn/database/mysql/some-thoughts-on-database-storage-time.html#时区信息