Tag archive

#primary-key

Commands grouped around the same concept, pattern, or recurring problem.

2 commands with this tag Browse related patterns quickly

beginner selecting MySQL MariaDB SQL Server PostgreSQL SQLite

Generate a UUID

Produce a random UUID using `UUID()` (MySQL/MariaDB), `NEWID()` (SQL Server), `gen_random_uuid()` (PostgreSQL), or a `randomblob`-based expression (SQLite).

intermediate defining MySQL MariaDB SQL Server PostgreSQL SQLite

Generate Row IDs Automatically

Define an identity or auto-increment column so new rows receive numeric IDs without the insert supplying them.