MySQL Table Maker

 

    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.
The VARCHAR fields hold two less characters than the field size. VARCHAR size can be anything from 3-255.
For Name, city, state,address, use theVARCHAR 64 or 128.
For phone numbers/Postal codes, use the VARCHAR 16.
For Email and URL fields and text (up to 253 characters), use VARCHAR(255) or TEXT types.
For raw numbers that will be part of numeric operations, or numeric fields that will serve as an id, 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. It lessens 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.
NOTE: This pageset now allows you to make the "whole shebang" Make a table, an insert form, and a query (search) form. Just start by making your table.   Enjoy!
Field 1:  
Field 2:  
Field 3:
Field 4:
Field 5:
Field 6:
Field 7:
Field 8:
Field 9:
Field 10:
Field 11:
Field 12:

| Home | PHP | Perl | JavaScript |