RPeraltaJr
9/3/2017 - 4:46 AM

SQL Queries

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