my-guitar-shop-database-exersices/How-to-insert-update-and-delete-data.sql

-- Exercise 1
INSERT INTO categories
VALUES 'Brass'

-- Exercise 2
UPDATE categories
SET category_name = 'Woodwinds'
WHERE category_id = 5

-- Exercise 3
DELETE FROM categories
WHERE category_id = 5

-- Exercise 4


-- Exercise 5


-- Exercise 6
INSERT INTO customers (email_address, password, first_name, last_name)
VALUES ('rick@raven.com', '', 'Rick', 'Raven')

-- Exercise 7
INSERT INTO customers (email_address, password, first_name, last_name)
VALUES ('rick@raven.com', '', 'Rick', 'Raven')

-- Exercise 8
UPDATE customers
SET password = "secret"
WHERE email_address = "rick@raven.com";

-- Exercise 9
UPDATE customers
SET password = "reset"
LIMIT 100

-- Exercise 10