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

Understanding how SQL databases work

By , About.com Guide

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

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. 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.