MySQL Upsert

mysql_upsert.sql

DROP TABLE IF EXISTS `things`;

CREATE TABLE `things` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nbr` int(11) NOT NULL,
  `thing` varchar(255) NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT NOW(),
  `updatedAt` datetime NOT NULL DEFAULT NOW() ON UPDATE NOW(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `nbr_unique` (`nbr`)
);

INSERT INTO `things` (nbr,thing) VALUES (1, 'A Thing') ON DUPLICATE KEY UPDATE thing = 'A Thing';
SELECT * FROM `things`;

INSERT INTO `things` (nbr,thing) VALUES (1, 'Another Thing') ON DUPLICATE KEY UPDATE thing = 'Another Thing';
SELECT * FROM `things`;

DELETE FROM `things`;