insert into test(name, sex) select t.name,t.sex from (values('1',‘男’), ('2',‘男’),('3',‘男’),('4',‘男’),('5',‘男’),('6',‘男’),...('1001',‘男’)) as t(name, sex)
临时表t暂存数据,然后再插入
insert into test(name, sex) select t.name,t.sex from (values('1',‘男’), ('2',‘男’),('3',‘男’),('4',‘男’),('5',‘男’),('6',‘男’),...('1001',‘男’)) as t(name, sex)
临时表t暂存数据,然后再插入