Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL Avoid Duplicates in INSERT INTO SELECT

INSERT INTO OldCustomers(customer_id, age)
SELECT customer_id, age
FROM Customers
WHERE NOT EXISTS(
  SELECT customer_id
  FROM OldCustomers
  WHERE OldCustomers.customer_id = Customers.customer_id
);
 
PREVIOUS NEXT
Tagged: #SQL #Avoid #Duplicates #INSERT #INTO #SELECT
ADD COMMENT
Topic
Name
9+8 =