mysql旧表去重数据导入新表且赋予主键id新值
标签：mysql数据导入 mysql旧表导入新 mysql导入主键值
mysql旧表去重数据导入新表且赋予主键id新值
INTO A表(id,n1,n2,n3)
select @row :=@row+1 AS id,t1.* from
(
SELECT DISTINCT n1,n2,n3 FROM B表
) t1,(select @row :=0) as t2