FUN WITH CODING
SQL QUICK REFERENCE

IN THIS SECTION

This section cover some of the most popular methods of manipulating, storing and accessing data from a database.  Most examples are give using SQLite however the principles apply to SQL with MySQL, SQL Server, MS Access and more.

​SQL SELECTION METHODS

SELECT ALL

SELECT DISTINCT

SELECT WHERE

SELECT WHERE, AND, OR, NOT

SELECT MIN AND MAX

SELECT WHERE LIKE and wildcards

select between

SQL INSERT METHOD

SQL UPDATE METHODS

SQL DELETE METHOD

SQL CREATING A DATABASE