mysql data copy from one table to another without duplicate value

Question

we have 2 table . we want to transfer table_1 data to table_2 with out duplicate data.

Table_1
----------
1

2

3

4
----------

Table_2
----------
2

4
----------

now we want to transfer Table_1 Values to Table_2 without duplicate. please tell me how to do in mysql query

Possible duplicate of How to insert records from table to another without duplicate — Jorden
– Jorden, Commented Apr 21, 2016 at 23:57

Strawberry · Accepted Answer · 2016-04-20 11:26:02Z

3

insert into table_2 
select * 
  from table_1 
 where column not in (select column from table_2);

Strawberry

34k14 gold badges43 silver badges57 bronze badges

answered Apr 20, 2016 at 11:17

Priyanshu

8816 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zafar Malik · Accepted Answer · 2016-04-20 11:05:51Z

2

First create unique index on the column (you want to keep unique) in table_2.

Now use below statement-

insert ignore into table_2 select * from table_1;

answered Apr 20, 2016 at 11:05

Zafar Malik

6,8723 gold badges23 silver badges31 bronze badges