1. 同表拷贝插入
insert into Table1(name,age,sex) select name,age,"Male" FROM Table1 where id=100
2. 不同表拷贝插入
insert into Table1(name,age,sex) select name,age,"Male" FROM Table2 where id=100
1. 同表拷贝插入
insert into Table1(name,age,sex) select name,age,"Male" FROM Table1 where id=100
2. 不同表拷贝插入
insert into Table1(name,age,sex) select name,age,"Male" FROM Table2 where id=100