Page 104 - CITS - CSA - TP (Volume 1) - Hindi
P. 104
कंप्यूटर सॉफ्टवेयर एप्लीकेशन- CITS
4 Using INSERT to add multiple rows at once
INSERT INTO my table(column name, column name 2)
VALUES
(‘value , ‘value2 ),
(‘value3 , ‘value4 ),
(‘value5 , ‘value6 );
Ex - INSERT INTO employee(first name, last name)
VALUES
(‘Abigail , ‘Spencer ),
(‘Tamal , ‘Wayne ),
(‘Katie , ‘Singh ),
(‘Felipe , ‘Espinosa );
For show the records
SELECT * FROM employee;
काय 2 : अ तन े री का उपयोग करना
Update Query:
UPDATE your table name
SET column1 = ‘new value1 , column2 = ‘new value2
WHERE condition;
88
CITS : IT & ITES - कं ूटर सॉ वेयर ए ीके शन - अ ास 27
