INSERT INTO StudAchieve(studID,studName) select '2','abc' union all select '2','bcd' union all select '2','cde'
INSERT INTO StudAchieve(studID,studName) select '2' studID,'abc' studName union all select '2','bcd' union all select '2','cde'
INSERT INTO StudAchieve(studID,studName) VALUES('2','abc')
--try INSERT StudAchieve(studID,studName) select '2','abc' union all '2','bcd' union all '2','cde'
INSERT INTO StudAchieve(studID,studName) VALUES('2','abc') INSERT INTO StudAchieve(studID,studName) VALUES ('2','bcd') INSERT INTO StudAchieve(studID,studName) VALUES('2','cde')
select '2','abc'
union all select '2','bcd'
union all select '2','cde'
select '2' studID,'abc' studName union all
select '2','bcd' union all
select '2','cde'
VALUES('2','abc')
INSERT
StudAchieve(studID,studName)
select
'2','abc'
union all
'2','bcd'
union all
'2','cde'
VALUES('2','abc')
INSERT INTO StudAchieve(studID,studName)
VALUES ('2','bcd')
INSERT INTO StudAchieve(studID,studName)
VALUES('2','cde')