SQL Programming

SELECT column, FROM table_name;

SELECT CustomerName FROM Customers;

WHERE condition;

SELECT * FROM Customers
WHERE Country=’Mexico’;

INSERT INTO table_name (column1, column2, column3, …)
VALUES (value1, value2, value3, …);

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES (‘Cardinal’, ‘Tom B. Erichsen’, ‘Skagen 21’, ‘Stavanger’, ‘4006’, ‘Norway’);

SELECT column
FROM table_name
WHERE column LIKE pattern
ORDER BY column ASC/DESC; (Default to ASC if not specified)

SELECT * FROM Customers WHERE CustomerName LIKE ‘j%’ ORDER BY CustomerName DESC;

SQL LIKE PATTERNS:

‘a%’	Finds any values that start with “a”
‘%a’	Finds any values that end with “a”
‘%a%’	Finds any values that have “a” in any position
‘_a%’	Finds any values that have “a” in the second position
‘a__%’	Finds any values that start with “a” and are at least 3 characters in length
‘a%o’	Finds any values that start with “a” and ends with “o”

DROP database; (Delete)

DROP DATABASE testdb;

DELETE FROM table_name WHERE condition

DELETE FROM Customers WHERE CustID = ‘A3’;

CREATE DATABASE name;

ALTER TABLE table_name …

• ADD column_name datatype
• DROP COLUMN column_name
• ALTER COLUMN column_name datatype

UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition; (If you dont put in WHERE then all records will be updated)

UPDATE Customers SET City = London WHERE Country = England;

Can put “*” to select everything.