Java bro

Java tutorial

Sql queries

Insert multiple rows at a time in sql

In this article we are going to learn how to insert multiple records into table using single statement .

Query :

INSERT INTO student (id, name) VALUES
(‘111′,’sree’),
(‘222′,’krish’),
(‘333′,’guru’)

Comments are Closed

Theme by Anders Norén