Defining a MySQL table

Defining a MySQL table can be accomplished most easily from the account control panel at http://www.mmaweb.net/login.html. This interactive script lets you add one column at a time to build your table.

A table consists of rows with columns of various types. The column types determine what kind of data can be inserted into it -- numerical, text or binary. A complete listing of column types is available in the MySQL documentation.

Generally, one of the columns of each table you create should be a key with a unique value. You can ensure the uniqueness of numerical column values by defining the column with the keyword auto_increment. This is an easy way to create a unique_id column for relational databases.

The complete list of options available in a CREATE TABLE statement are as follows:

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name

[(create_definition,...)] [table_options] [select_statement] create_definition: col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [PRIMARY KEY] [reference_definition] or PRIMARY KEY (index_col_name,...) or KEY [index_name] (index_col_name,...) or INDEX [index_name] (index_col_name,...) or UNIQUE [INDEX] [index_name] (index_col_name,...) or [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...) [reference_definition] or CHECK (expr)

Note: MMA technical support staff cannot provide troubleshooting of problems with third-party CGI scripts including but not limited to: Perl scripts, C/C++ binaries, PHP or web/database integration unless these services are specifically contracted. For these services, please see our Quote Request Form.