SQL向同一张表复制数据,仅改动个别栏位 Insert into table(Name,Age,Sex,Nickname,Work) select top 1 b.Name, b.Age, b.Sex, b.Name AS Nickname,'客服' from table b where b.Name='小红';