This section covers the most basic SQL commands.

Below is a table called names.

To select all of the table :

SELECT *
FROM names

To select the SecondName fields only :

SELECT SecondName
FROM names

To select the SecondName fields only in alphabetical order (a-z) :

SELECT SecondName
FROM names
ORDER BY SecondName

To select the ID fields and the SecondName fields in reverse alphabetical order (z-a) :

SELECT SecondName, ID
FROM names
ORDER BY SecondName DESC

Section 2 :

This section covers the insert, update and delete SQL commands.

To insert a new field in the table :

INSERT INTO names
(Title, FirstName, SecondName)
VALUES ('Mr', 'William', 'Shakespear')

To update a field within the table :

UPDATE names
SET SecondName = 'Wordsworth'
WHERE ID = 76

To delete a field within the table :

DELETE FROM names
WHERE (ID = 76)