MySQL Table Maker - by TSoft

    Once you submit, copy the text off the form and paste it into your PhpMyAdmin QUERY WINDOW for your MySQL database. You have to create a database first.
1. Type in a Table Name (No Spaces or special characters - You're safe with A-Z, 1-9,_), and don't use RESERVED WORDS.
2. Type in field names. You can use as many as you need, and you can skip some. Blanks won't be submitted. No spaces, reserved words or special characters.
3. Select a type for each field. The top drop-down next to Field Types and descriptions will tell you about field types.
The last field type has an option for TIMESTAMP, which will automatically stamp your field with YYYYMMDD.
The common field types are shown here. An index will be added at the end of your table.

Table Name: The VARCHAR(4) selection below is only for a 2-letter State field.
Field Types
and descriptions		     
Field Names Field Types

Some Guidelines (please read):
You cannot use spaces in table or field names.
You need to set a type for each field. This contains the most common types of table fields. For Name, city, state,address and phone fields, use theVARCHAR 64 or 128. For Email and URL fields, use VARCHAR(255) or TEXT types. For Zip code use a VARCHAR(32).
For raw numbers that will be part of numeric operations, use the INT fields.
For fields that will hold less than say a page of text, use the TEXT type. For more than a page, use the MEDIUMTEXT field. For a field that is going to, well, hold a book, use the LONGTEXT. Don't try to create a lot of 'overhead' by creating bigger fields than you need by a wide margin. This will lessen the efficiency of your database. You can see above what the TEXT type fields hold. It's a lot.
This form creates a default, normally dynamic MyISAM table. For more information on table types, click on a "Documentation" link in the MySQL section of your control panel.
Field 1:  
Field 2:  
Field 3:
Field 4:
Field 5:
Field 6:
Field 7:
Field 8:
Field 9:
Field 10:
Field 11:
Field 12: