SQL

Basics

Select

The SELECT statement is used to assemble fields of different tables and queries to a new result.

Examples

• Selecting all fields from a table

SELECT *
  FROM tbl

• Selecting two fields from a table

SELECT field1
     , field2
  FROM tbl

Insert

• INSERT INTO

Update

• UPDATE

Delete

• DELETE