AI agents: Read [llms.txt](https://kysely.dev/llms.txt) for the documentation index and links to Markdown (.md) versions of individual pages. Read [llms-full.txt](https://kysely.dev/llms-full.txt) for the full documentation in one file.

* [](https://kysely.dev/index.md)
* Examples

# Examples

Short and simple examples of how to use Kysely to achieve common tasks.

## [🗃SELECT](https://kysely.dev/docs/category/select.md)

[14 items](https://kysely.dev/docs/category/select.md)

## [🗃WHERE](https://kysely.dev/docs/category/where.md)

[6 items](https://kysely.dev/docs/category/where.md)

## [🗃JOIN](https://kysely.dev/docs/category/join.md)

[4 items](https://kysely.dev/docs/category/join.md)

## [🗃INSERT](https://kysely.dev/docs/category/insert.md)

[5 items](https://kysely.dev/docs/category/insert.md)

## [🗃UPDATE](https://kysely.dev/docs/category/update.md)

[3 items](https://kysely.dev/docs/category/update.md)

## [🗃DELETE](https://kysely.dev/docs/category/delete.md)

[1 item](https://kysely.dev/docs/category/delete.md)

## [🗃MERGE](https://kysely.dev/docs/category/merge.md)

[2 items](https://kysely.dev/docs/category/merge.md)

## [🗃Transactions](https://kysely.dev/docs/category/transactions.md)

[3 items](https://kysely.dev/docs/category/transactions.md)

## [🗃CTE](https://kysely.dev/docs/category/cte.md)

[2 items](https://kysely.dev/docs/category/cte.md)

[Previous](https://kysely.dev/docs/migrations.md)

[Migrations](https://kysely.dev/docs/migrations.md)

[Next](https://kysely.dev/docs/category/select.md)

[SELECT](https://kysely.dev/docs/category/select.md)
