In this article we are going to learn how to insert multiple records into table using single statement .
Query :
Query :
INSERT INTO student (id, name) VALUES
(‘111′,’sree’),
(‘222′,’krish’),
(‘333′,’guru’)
(‘111′,’sree’),
(‘222′,’krish’),
(‘333′,’guru’)