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

MySQL Tutorial: Create SQL Tables

By Angela Bradley, About.com

2 of 4

Adding Rows and Columns

Creating database fields
Let's say we work in a doctor's office and wanted to make a simple table with a person's name, age, height, and the date we collected this information. On the previous page we entered "people" as the name of our table, and chose to have 4 fields. This brings up a new phpmyadmin page where we can fill in the fields and their types to add rows and columns. (See an example above)

We have filled in the field names as: name, age, height, and date. We have set the data types as VARCAR, INT (INTEGER), FLOAT and DATETIME. We set a length of 30 on the name, and have left all other fields blank.

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 Add Column - phpMyAdmin tutorial - Add Column phpMyAdmin

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

All rights reserved.