LMSouq
general-dev Open

INSERT ... ON DUPLICATE KEY (do nothing)

UF
ufk
1 month ago
3 views
Problem Description
I have a table with a unique key for two columns: CREATE TABLE `xpo`.`user_permanent_gift` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `fb_user_id` INT UNSIGNED NOT NULL , `gift_id` INT UNSIGNED NOT NULL , `purchase_timestamp` TIMESTAMP NULL DEFAULT now() , PRIMARY KEY (`id`) , UNIQUE INDEX `user_gift_UNIQUE` (`fb_user_id` ASC, `gift_id` ASC) ); I want to insert a row into that table, but if the key exists, to do nothing! I don't want an error to be generated because the keys exist. I know that there is the following syntax: INSERT ... ON DUPLICATE KEY UPDATE ... but is there something like: INSERT ... ON DUPLICATE KEY DO NOTHING ?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base