INSERT INTO brand(id,brand,brand_url) SELECT id,brand,brand_url FROM data a WHERE NOT EXISTS( SELECT * FROM data WHERE brand=a.brand AND id<a.ID )
关键是看你如果重复的话,你的brand_url取哪一个值
insert into brand(id,brand,barand_url) select id,brand,brand_url from data t where not exists(select 1 from data a where t.brand=a.brand and checksum(t.id,t.brand_rul)<checksum(a.id,a.brand_url))--orinsert into brand(id,brand,barand_url) select id,brand,brand_url from data t where not exists(select 1 from data a where t.brand=a.brand and checksum(t.id,t.brand_rul)>checksum(a.id,a.brand_url))
INSERT INTO brand(id,brand,brand_url) SELECT id,brand,brand_url FROM data a WHERE NOT EXISTS( SELECT * FROM data WHERE brand=a.brand AND id<a.ID ) 关键看你取ID大的还是小的 自己修改下~~
brand相同的情况下,brand_url的值也是相同的
那就去掉id字段INSERT INTO brand(brand,brand_url) SELECT brand,brand_url FROM data a WHERE NOT EXISTS( SELECT * FROM data WHERE brand=a.brand AND id <a.ID )
insert brand select max(id),brand,brand_url from data group by brand,brand_url
insert brand select min(id),brand,brand_url from data group by brand,brand_url --这是ID最小值
SELECT id,brand,brand_url
FROM data a
WHERE NOT EXISTS(
SELECT * FROM data WHERE brand=a.brand AND id<a.ID
)
insert into brand(id,brand,barand_url)
select id,brand,brand_url
from data t
where not exists(select 1 from data a where t.brand=a.brand and checksum(t.id,t.brand_rul)<checksum(a.id,a.brand_url))--orinsert into brand(id,brand,barand_url)
select id,brand,brand_url
from data t
where not exists(select 1 from data a where t.brand=a.brand and checksum(t.id,t.brand_rul)>checksum(a.id,a.brand_url))
SELECT id,brand,brand_url
FROM data a
WHERE NOT EXISTS(
SELECT * FROM data WHERE brand=a.brand AND id<a.ID )
关键看你取ID大的还是小的
自己修改下~~
那就去掉id字段INSERT INTO brand(brand,brand_url)
SELECT brand,brand_url
FROM data a
WHERE NOT EXISTS(
SELECT * FROM data WHERE brand=a.brand AND id <a.ID )
select max(id),brand,brand_url from data group by brand,brand_url
insert brand
select min(id),brand,brand_url from data group by brand,brand_url
--这是ID最小值