Download to read offline
Uploaded byMySQLConference
1,036 views
Solving Common Sql Problems With The Seq Engine
This document discusses using sequence tables in SQL to generate sequences of numbers or timestamps to solve problems like finding missing rows in tables. It introduces the SeqEngine, a pluggable storage engine for MySQL that allows automatically generating sequence tables without manually populating them. The SeqEngine provides a simple way to create read-only sequence tables from a specified start, end, and increment value. Some examples of using LEFT JOIN or NOT EXISTS to find missing rows by joining a sequence table against a table are provided.