JSP Hosting

HostingServicesSupportOrderAbout UsSoftwareHome

Even experts read the manuals. Our tech support staff has most of the books that are out on a wide variety of web topics. Here are some of their top picks. We think you'll find them useful and informative as well.

Defining a MySQL table

Defining a MySQL table can be accomplished most easily from the account control panel at http://www.mmaweb.net/login.php. 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_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.

Copyright © 1995-2012
Motivational Marketing Associates, LLC
All Rights Reserved.