SQL INSERT, UPDATE and DELETE

INSERT

SQL
INSERT INTO employees (name, dept, salary, city)
VALUES ('Asha', 'IT', 65000, 'Pune'),
       ('Ravi', 'HR', 42000, 'Mumbai'),
       ('Meera', 'IT', 78000, 'Pune'),
       ('Karan', 'Sales', 51000, 'Delhi'),
       ('Neha', 'HR', 47000, 'Pune');
Query OK, 5 rows affected

UPDATE

SQL
UPDATE employees
SET salary = salary * 1.10
WHERE dept = 'HR';
Query OK, 2 rows affected
Always use WHEREUPDATE or DELETE without a WHERE clause changes every row in the table.

DELETE

SQL
DELETE FROM employees WHERE id = 4;
Query OK, 1 row affected
Track your progress through the SQL course