北大青 7E 男 插入多行数据4-4 NSERT|NTO<表名>(列名) SELECT<列名>UNON SELECT<列名>UNON INSERT STUDENTS (SName, SGrade, SSex SELECT测试女生1,7,0UN|ON SELECT测试女生2,7,0UNON SELECT测试女生3,7,0UN|ON SELECT测试女生4,7,0UN|ON SELECT测试女生1,7,0UN|ON SELECT测试男生2,7,1UNON SELECT测试男生3,7,1UN|ON SELECT测试男生4,7,1UN|ON SELECT测试男生5,7,1 ACCP V4.0ACCP V4.0 23 插入多行数据 4-4 INSERT STUDENTS (SName,SGrade,SSex) SELECT '测试女生1',7,0 UNION SELECT '测试女生2',7,0 UNION SELECT '测试女生3',7,0 UNION SELECT '测试女生4',7,0 UNION SELECT '测试女生1',7,0 UNION SELECT '测试男生2',7,1 UNION SELECT '测试男生3',7,1 UNION SELECT '测试男生4',7,1 UNION SELECT '测试男生5',7,1 INSERT INTO <表名>(列名) SELECT <列名> UNION SELECT <列名> UNION ……