| Below are the 3 main methods which helps in inserting multiple records in sql table table at one time.
(1)Simple Insert method
INSERT INTO TableName VALUES ("Ram", 1, "crackyourinterview.com");
INSERT INTO TableName VALUES ("Shyam”, 2, "Interviewqsn.com");
INSERT INTO TableName VALUES ("Sachin", 3, "kharchabachao.com");
INSERT INTO TableName VALUES ("Anil”, 123, "crackyourinterview.com");
(2)Another method to insert values shortcut
insert into TableName (Name,Id,WebsiteName) values (‘Ram’, 1,’crackyourinterview.com’),
("Shyam”, 2, "Interviewqsn.com"),
("Sachin", 3, "kharchabachao.com"),
("Anil”, 123, "crackyourinterview.com");
(3)Third Method here we used INSERT with SELECT UNION ALL:
INSERT INTO TableName (Name,Id,WebsiteName)
SELECT ‘Ram’ ,1,’Crackyourinterview.com’
UNION ALL
SELECT ‘Shyam’, 2, ‘Interviewqsn.com’
UNION ALL
SELECT ‘Sachin’, 3, ‘kharchabachao.com’ | | |