Question

Consider the following table Stationary. Write SQL commands for following statement.

S_ID	S_Name	C_Name	Price	Quantity
001	Note Book	ABC	20	50
002	Pencil Box	XYZ	10	80
003	A4 Pages rim	PQR	600	2

Write SQL command to insert above mentioned record in table

Answer 1

INSERT INTO Stationary values
(001, 'Note Book', 'ABC', 20, 50)
(002, 'Pencil Box', 'XYZ', 10, 80)
(003, 'A4 Pages rim', 'PQR', 600, 2);