This book is not intended to be a database or SQL primer, but it will help to have an understanding of how traditional interaction with a database using SQL occurs.
First, consider a database to be one or more tables, just like a spreadsheet. The vertical columns comprise different fields or categories; they are analogous to the fields you fill out in a form. The horizontal rows are individual records; each row is one complete record entry. Here is a pictorial summary, representing a customer list. The table's name is Customers:
|
Index |
LName |
FName |
Address |
City |
State |
|
0 |
Johnson |
Jack |
123 Easy St. |
Anywhere |
CA |
|
1 |
Smith |
John |
312 Hard St. |
Somewhere |
NY |
The only column that needs ...
