Cheat Sheet logoCheat Sheet Today
MySQL SELECT, INSERT, UPDATE, and DELETE Cheatsheet/Upsert with ON DUPLICATE KEY UPDATE

Insert a row or update it when a unique key already exists.

Back to sheetBrowse commands
Sign in to save
Section: insert, update, and delete

Upsert with ON DUPLICATE KEY UPDATE

sql
sql
INSERT INTO users (email, full_name)
VALUES ('ava@example.com', 'Ava Stone')
ON DUPLICATE KEY UPDATE full_name = VALUES(full_name);
Explanation

A classic MySQL upsert pattern for unique-keyed rows.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing insert, update, and delete
Replace a row using REPLACE
Insert or delete-and-insert based on unique key conflicts.
OpenIn sheetsqlsame section
Insert one row
Create a new row with explicit columns.
OpenIn sheetsqlsame section
Insert multiple rows
Create several rows in one statement.
OpenIn sheetsqlsame section
Update matching rows
Change values for rows that match a filter.
OpenIn sheetsqlsame section
Delete matching rows
Remove rows that match a predicate.
OpenIn sheetsqlsame section
Truncate a table
Remove all rows quickly and reset auto-increment counters.
OpenIn sheetsqlsame section