Tag archive

#random

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 selecting MySQL MariaDB SQL Server PostgreSQL SQLite

Select Random Rows

Return a random sample by ordering rows with the engine's random function and applying a row limit.