Support Manual

Table Properties

The fields in the table are listed with their datatypes and attributes.

Next to each field name are links to various actions you can perform on a field.

• Change Change the attributes of a field.
  

• Drop Delete the field from the table. Once you do this the data will be no longer available.
  

• Primary Set the field to be a primary field.
  

• Index Create an index on the field for faster searching.
  

• Unique Require all values in the field to be unique.

Primary fields and indexes
The primary fields and indexes are listed again below the list of all fields.

Browse
Display the records in the table 30 at a time. From the Browse page you can edit or delete a record.

Select
Build and execute a SELECT query on the table. Only those records which match the criteria you provide will be displayed.

Insert
Add a new record to the table. Various functions can be used to obtain the current time, generate random numbers, and more.

Add New Fields
To add one or more new fields to the table, select the number of fields to add and press the Go button next to the text Add new field:.

Upload Data
Insert textfiles into table allows you to load data into the table from a properly formatted text file on your local computer.

Dump Table Properties
View dump (schema) of table displays the structure and or data contained in the table. You can then save this information to a file on your local computer for archiving or to aide in the development of your database. The contents and format of the dump are based on the radio button and check box selections you make.

Rename and Copy
Allows you to rename or copy a table.

Overview 

MySQL Control Panel Feature

Examples of SQL Statements 

 Quick Actions

Advanced Queries

Table Properties

Table Select 
Perl While Loop Example
Using MySQL With CGI Scripts
References and Tutorials

 

 

Copyright © 2003-2007 Hosting Connecticut, LLC.
Resellers of Hosting Connecticut, LLC. may reproduce this manual on their sites.