Auto Increment Primary Key and Foreign Key Tutorial in PHP MySQL AUTO INCREMENT Field Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table.

In this tutorial, we will step through installing PostgreSQL, connecting to the database, loading some data, and running a variety of SQL queries.

In Microsoft SQL Server, for example, a primary key usually equates to a clustered index. In SQLite, a primary key is usually just a unique index and is distinct from the special rowid column name.