Communities for your favorite technologies. Explore all Collectives
Now available on Stack Overflow for Teams! AI features where you work: search, IDE, and chat.
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams
Find centralized, trusted content and collaborate around the technologies you use most.
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Get early access and see previews of new features.
Yes,Use INSERT ... ON DUPLICATE KEY UPDATE. For example:
INSERT ... ON DUPLICATE KEY UPDATE
INSERT INTO `usage` (`thing_id`, `times_used`, `first_time_used`) VALUES (4815162342, 1, NOW()) ON DUPLICATE KEY UPDATE `times_used` = `times_used` + 1
Yes, INSERT ... ON DUPLICATE KEY UPDATE. For example:
Use INSERT ... ON DUPLICATE KEY UPDATE. For example:
Yes, INSERT ... ON DUPLICATE KEY UPDATEINSERT ... ON DUPLICATE KEY UPDATE. For example: