Topic: sqlite

• Upsert, row limits and identifier quoting across PostgreSQL, MySQL, SQLite and SQL Server

  PostgreSQL's ON CONFLICT, MySQL's ON DUPLICATE KEY UPDATE, SQLite's PostgreSQL-style ON CONFLICT and SQL Server's MERGE are three families of upsert syntax, LIMIT/OFFSET has at least three shapes, and a quoted identifier means double quotes, backticks or square brackets depending on the engine.

  article · en · reviewed · knowledge as of 2026-09-25

Machine-readable: JSON