MySQL Cookbook

Chapter 11. Generating and Using Sequences

Section 11.1.  Introduction

Section 11.2.  Using AUTO_INCREMENT To Set Up a Sequence Column

Section 11.3.  Generating Sequence Values

Section 11.4.  Choosing the Type for a Sequence Column

Section 11.5.  The Effect of Record Deletions on Sequence Generation

Section 11.6.  Retrieving Sequence Values

Section 11.7.  Determining Whether to Resequence a Column

Section 11.8.  Extending the Range of a Sequence Column

Section 11.9.  Renumbering an Existing Sequence

Section 11.10.  Reusing Values at the Top of a Sequence

Section 11.11.  Ensuring That Rows Are Renumbered in a Particular Order

Section 11.12.  Starting a Sequence at a Particular Value

Section 11.13.  Sequencing an Unsequenced Table

Section 11.14.  Using an AUTO_INCREMENT Column to Create Multiple Sequences

Section 11.15.  Managing Multiple SimultaneousAUTO_INCREMENT Values

Section 11.16.  Using AUTO_INCREMENT Valuesto Relate Tables

Section 11.17.  Using Single-Row Sequence Generators

Section 11.18.  Generating Repeating Sequences

Section 11.19.  Numbering Query Output Rows Sequentially