Interactive SQL Tutorial

1. Introduction into SQL (Structured Query Language)

Structured Query Language is the standard language used to communicate with database software. DB to HTML Express uses SQL to query the database for the data that will be included in the web site. SQL is a complex and powerful language and a full treatment of it is outside the scope of this text, however a few useful SQL commands are:

1. To make the entire contents of a datasource table "Tablename" accessible to DB to HTML Express: “SELECT * FROM Tablename”

2. To retrieve all the records from datasource table “Tablename” where the value of ColumnName is 5: “SELECT * FROM Tablename WHERE Tablename.ColumnName=5”

3. To retrieve all the records from one column called ColumnName from a datasource table called Tablename:
“SELECT ColumnName FROM Tablename”

4. To retrieve all the records from datasource table “Tablename” where the text in column ColumnName contains the word ‘television’:
“SELECT * FROM Tablename WHERE Tablename.ColumnName LIKE ‘%television%’”

1 2 3 4 5 6 7 8 9 10 11 12 13 Next >>