All topics
Database · Learning hub

MySQL cheat sheet & developer notes

MySQL cheat sheet and 1 curated developer notes — core concepts, patterns, and interview prep. Maintained by the DevRecall team.

Save this stack to your DevRecallTest yourself — MySQL quizMore Database notes
01 · MySQL

Queries & Schema

MySQL — Queries & Schema. Schema Definition. -- Create database CREATE DATABASE myapp CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; USE myapp; -- Create table CREATE TABLE users ( id BIGINT UNSIGNED AUTO_INCREMENT PR…

Read

Concepts to know for MySQL

All topics →
Database IndexingWhat a B-tree index actually is, how the planner decides to use it, why column order in a composite index matters, and when an index makes things worse.Intermediate·14 minDatabase Sharding and PartitioningHow a partition key splits a table, why sharding the pieces across machines makes that key decide every query, and how to reshard without downtime.Advanced·14 minOptimistic vs Pessimistic LockingStop concurrent writers overwriting each other: lock the row before reading, or check a version on write. When each wins and how to build both.Intermediate·13 minTransactions and Isolation LevelsWhat each isolation level actually prevents, how MVCC lets readers and writers coexist, and the three patterns that stop lost updates and double-bookings.Intermediate·14 minSQL Injection: How It Works and How to Stop ItWhy gluing input into SQL text lets data become code, why bind parameters fix it for good, and where ORMs, identifiers and stored procedures still leak.Intermediate·13 min

Related stacks

CassandraCockroachDBCouchDBDrizzleDrizzle ORMDynamoDBElastiCacheElasticsearchEventStoreInfluxDBMariaDBMemcached
Browse all stacks →

Keep your MySQL knowledge sharp.

Save this stack to your personal DevRecall — add your own notes, track what you're learning, and share what you know with the community.

Get started — free forever