SQL insert into 多行(同時添加多行)
運行sql語句:
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
select 'Projet',112,94 ,100
union all select 'Projet',112,94 ,10
效果:
AppID | DegreeID | RoleID | NodeID |
Projet | 112 | 94 | 100 |
Projet | 112 | 94 | 10 |
NULL | NULL | NULL | NULL |