Account
Overview
Getting Started
Control Panel
FTP
Email Client Setup
HELPFUL TIPS
MySQL
Overview
| MySQL Control Panel Feature | Examples
of SQL Statements | Quick Actions
Advanced Queries | Table Properties | Table Select
Perl SQL Update Example | Perl While Loop Example
View Dump Database Schema
| Using MySQL With CGI Scripts
References and Tutorials
Table
Properties
The fields in the table are listed with their datatypes and attributes.
The List of Fields
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 seaching.
- Unique Require
all values in the field to be uniq ue.
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
You can rename or copy a table as well.
Copyright © 2000-2004 All rights reserved, Web and Print Design trading as www.webandprint.com.au