Insert Multiple records with single Insert statement

For entering data in table we will write below command.

insert into persons
(
p_id, First_Name, Last_Name, Address, city
)
values
(
'2', 'Shyam', 'Kumar', 'Address2', 'city2'
)

insert into persons
(
p_id, First_Name, Last_Name, Address, city
)
values
(

'3', 'ghanShyam', 'Kumar', 'Address3', 'city3'
)


It will enter 2 records in database. The same functionality may be achieved by Single Insert Statement.

Solution:

insert into persons
(
p_id, First_Name, Last_Name, Address, city
)
select '2', 'Shyam', 'Kumar', 'Address2', 'city2'
unial all
select '3', 'ghanShyam', 'Kumar', 'Address3', 'city3'

It will insert two records in table.

Click here to go on website