Chapter 4: Using SQL

Basic Select statements (p. 71)

SELECT some_stuff
FROM a_table
WHERE conditions_are_true;

and

SELECT product_name, product_description
FROM product_catalog
WHERE product_id = 4;

Requesting multiple records (p. 72)

SELECT product_id, product_name, product_description
FROM product_catalog
WHERE product_id <=10;

The INSERT statement (p. 73)

INSERT into table_name
(column1, column2,...columnN)
values (value1, value2,...valueN)

and

INSERT into product_catalog
(product_ID, product_name, product_description)
values (99, 'Fish Food', 'Healthy food for your little fishies!')

The UPDATE statement (p. 73)

UPDATE table_name
SET column_name = new_value
WHERE condition_is_true;

and

UPDATE product_catalog
SET product_name = 'Healthy Fish Food'
WHERE product_name = 'Fish Food';

Updating multiple records (p. 74)

UPDATE product_catalog
SET product_name = 'Fish Food', product_description = 'Food for your little fishies!'
WHERE product_ID = 99;