Chapter 24 - MySQL



Quick Actions

For quick step by step tutorial on how to perform common functions, click below. For all of the examples, you must first login to your Control Panel and then into your MySQL feature and go to the Main Database Management Page of your MySQL database.
  • Create a table
  1. Type in the name of the new table and the number of fields for the table in the textboxes provided.
  2. Press the Go button next to the Fields textbox.
  3. Enter in the name of each field and the datatype of the field. Other attributes of the field can be set as well. Length of char strings, not null, default value are commonly used attributes.
  4. You can also specify primary fields, indexes and unique fields here as well. These can also be set for individual fields from the table properties page.
  5. If everything is correctly specified, when you press the Save button the table will be created and you will end up on the table properties page for the new table.
  • Add a record
  1. From the Main Database Management Page or the table properties page press the Insert link.
  2. Enter in a value for each field. You must provide a value for any field which set not null and has no default value. If you do not provide a value the default value will be used if provided. The functions in the menu can be used to generate a value for the field for you. Note that the functions may require a value to operate on.
  3. Press the Save button.
  • Perform a search
  1. From the Main Database Management Page or the table properties page press the Select link.
  2. Fill out the form fields as described here.
  3. Press the Go button.
Many other operations can be performed by using the MySQL Control Panel.




©Copyright 2000 . All Rights Reserved.
The entire contents of this site is copyrighted and may not be reproduced for any purpose without prior written permission.
Table Of Contents:

Back To Index
|
Chapter 1
FTP Instructions

|
Chapter 2
SSH / Telnet

|
Chapter 3
Email Software Setup

|
Chapter 4
CGI Bin

|
Chapter 5
Secure Server

|
Chapter 6
Formmail

|
Chapter 7
Microsoft Front Page

|
Chapter 8
CGI Scripts

|
Chapter 9
COMING SOON

|
Chapter 10
COMING SOON

|
Chapter 11
Streaming Audio/Real Video

|
Chapter 12
File Manager

|
Chapter 13
Mail Manager

|
Chapter 14
Changing Passwords

|
Chapter 15
Site Statistics

|
Chapter 16
Network Tools

|
Chapter 17
FTP & Anon FTP

|
Chapter 18
SSH / Telnet

|
Chapter 19
Password Protect Directories

|
Chapter 20
Custom Error Pages

|
Chapter 21
MySQL

|
Chapter 22
Mime Types

|
Chapter 23
Crontab

|
Chapter 24
Entropy Chat

|
Chapter 25
Shopping Cart

|
Chapter 26
Search Engine Submission

|
Chapter 27
PGP

|
Chapter 28
Subdomains

|
Chapter 29
Archive Manager

|