1. Home
  2. Computing & Technology
  3. PHP / MySQL

Understanding how SQL databases work

By Angela Bradley, About.com

2 of 4

What are SQL tables?

SQL Table

A SQL table is made of intersecting rows and columns

A database can be made up of many tables, and a table in a database is made up of intersecting columns and rows that form a grid. A good way to think about this is to imagine a checker board. Along the top row of the checkerboard there are labels for the data you wish to store, for example Name, Age, Gender, Eye Color, etc. In all the rows below, information is stored. Each row is one entry (all the data in a single row, belongs to the same person in this case) and each column contains a specific type of data as indicated by its label. Here is something to help you visualize a table:
Explore PHP / MySQL
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. Learn MySQL
  5. SQL tutorial - MySQL Tutorial - SQL Table

©2009 About.com, a part of The New York Times Company.

All rights reserved.