SQL Queries
# Read all data from table
SELECT * FROM jobs
# Read all data by specific author
SELECT * FROM posts WHERE author = '$author'
# Update data
UPDATE Customers
SET ContactName='$contact_name', City='$city'
WHERE CustomerName='$contact_name';
# Delete data
DELETE FROM Customers
WHERE CustomerId='$customer_id'
# Get a list of every unique city in the column
SELECT DISTINCT City FROM Customers