CREATE TABLE IF NOT EXISTS acceptance_customers ( id BIGINT PRIMARY KEY, customer_name VARCHAR(100) NOT NULL ); INSERT INTO acceptance_customers (id, customer_name) VALUES (1, 'Alpha'), (2, 'Beta') ON DUPLICATE KEY UPDATE customer_name = VALUES(customer_name);