MySQL

Use JdbcTemplate, method annotations, Mapper files, or the Builder API with MySQL. The following pages cover database-specific configuration and usage.

Scenario	Usage
Key generation	AUTO_INCREMENT backfill
Pagination	LIMIT pagination
Insert conflicts	INSERT IGNORE / ON DUPLICATE KEY UPDATE

• Programmatic API: queries, writes, multiple results, and stored routine differences.
• Mapper API: annotations, Mapper reads and writes, and execution differences.
• Builder API: Supported operations, datasource-specific behavior, and usage.
• Pagination: Page queries and total counts.
• Insert Conflicts: Handle existing records during insertion.
• Key Generation: Configure and retrieve IDs.
• Type Support: Choose Java property types.
• Transaction Support: Roll back multiple writes on failure.