Page 101 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - 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;

TASK 2 : Using update query
Update Query:
UPDATE your table name
SET column1 = ‘new value1’, column2 = ‘new value2’
WHERE condition;

86
CITS : IT & ITES - Computer Software Application - Exercise 27