SQL Query that will migrate all Unique data from same database

user_10586855 0
Viewed 31

enter image description here

Can someone help me write a query that will copy all Unique occurences from Table1 (id_objects,tags) and put them in table 2 .Id_objects on id_objects , tags on code in table 2 and tags on title in table 3

mysql sql
1 Answers

Is this what you wish to achieve?

insert into table2 (id_objects, code)
    select distinct id_objects, tags from table1
user_110471740
Related