Louisville Web Design - Online Stores
Marketing - Advertising
Payment Processing Solutions
Business Integration - Intranet Portal
Custom Software - Mobile Apps
Increase Your Profit Margin

Website Design Company

Business Integration Made Easy!

Phone: +1 (502) 439-8692
This email address is being protected from spambots. You need JavaScript enabled to view it.

Creating The Website Database Table

The database table or tables can contain any type of data you need to store for your website.  Our databases range from simple to very complex.

Some uses for webstie database storage:

  • User or Customer Information
  • Applications
  • Marketing Data
  • Reporting
  • Job Schedules
  • Sales Schedules
  • Customer Accounts
  • Any other type of user interaction with your website

 

Here is what the table looks like for this Tutorial:

Field Type Null Default
id  int(11) Yes  NULL 
date  date Yes  NULL 
type  varchar(150) Yes  NULL 
company  varchar(150) Yes  NULL 
total  decimal(6,2) Yes  NULL 
region  varchar(100) Yes  NULL 

 

Here is the MySQL statement to create the table:

CREATE TABLE `ims_data_tutorial` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `type` varchar(150) NOT NULL,
  `company` varchar(150) NOT NULL,
  `total` decimal(6,2) NOT NULL,
  `region` varchar(100) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

Website Design by iMarketing Solutions