|
|
|
In SQL, if we want to enter multiple records using SQL . we can do it in two ways
|
Suppose there is one table named as student with following columns:
|
Student
|
|
Column Name |
Data Type
|
Nullable
|
|
StudentID |
INT
|
No
|
|
StudentName |
Varchar(128)
|
No
|
|
StudentClass |
Varchar(15)
|
No
|
|
StudentContact |
Varchar(1024)
|
No
|
|
Description |
Varchar(2048)
|
Yes
|
To insert 10 students records we can either write 10 INSERT statements or we can write 1 INSERT statement
1.
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student A','10th Class','9876543210','Description 10'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student B','9th Class','8765432109','Description 9'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student C','8th Class','9876543210','Description 8'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student D','7th Class','7654321098','Description 7'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student E','6th Class','6543210987','Description 6'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student F','5th Class','5432109876','Description 5'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student G','4th Class','4321098765','Description 5'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student H','3rd Class','3210987654','Description 3'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student I','7th Class','7654321098','Description 7'
)
INSERT INTO TABLE Student(StudentName,StudentClass
,StudentContact
,Description)
VALUES('Student E','7th Class','6543210987','Description 6'
)
|
|
|