Chapter 1
Account Overview
Chapter 2
Getting Started
Chapter 3
Control Panel Overview
Chapter 4
FTP Instructions
Chapter 5
SSH / Telnet
Chapter 6
Email Software Setup
Chapter 7
File Manager
Chapter 8
Change Password
Chapter 9
Mail Manager
Chapter 10
Site Statistics
Chapter 11
Mailing List
Chapter 12
Microsoft FrontPage
Chapter 13
Site Creation Tool
Chapter 14
Counters
Chapter 15
Protect Directories
Chapter 16
Redirect URL
Chapter 17
Search Engine
Chapter 18
Formmail
Chapter 19
PGP & PGP Mail
Chapter 20
Mime Types
Chapter 21
Anonymous FTP
Chapter 22
Archive Manager
Chapter 23
SSL (Secure Server)
Chapter 24
MySQL
Chapter 25
Shopping Cart
Chapter 26
CGI-bin
Chapter 27
Real Audio / Real Video
|
|
Chapter 24 - MySQL
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.
|