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
MySQL Overview
SQL stands for Structured Query Language.
It is the most common language used for accessing a database. It has been in use for many
years by many database vendors. Many consider it the best database language to use. It is
used by the MySQL database feature inside your control panel.
Without going into the technical details, SQL is a language which consists of a
set of commands that you issue to create, make changes to, and retrieve data from a
database. Here are some SQL command examples.
These commands can be issued through a Graphical User Interface
or by embedding them in a computer program that you write.
The MySQL Control Panel provided as part
of your account is a GUI that works over the internet through your web browser. This makes
it very convenient for administration of web based database applications. Setting up and
managing your database will be done through the MySQL
Control Panel.
To allow access to your database through your web site, you will need to create
Common Gateway Interface scripts. These scripts are small computer
programs which run on the web hosting server and are activated by clicking on a link or a
button in a web page. This will allow users of your web site to interact with your web
site in a more meaningful manner. Using CGI scripts and MySQL you can maintain account
information on visitors, allow people to search and browse catalogs, and much more. See Using MySQL with CGI scripts for documentation on
how to set up such scripts.
MySQL is an implementation of the SQL language developed by TcX. It is robust, quick, and very flexible. It provides
all of the standard SQL datatypes and commands. MySQL is provided as part of your web site
account at no additional charge. MySQL is pronounced “My Ess Que Ell.”
For step by step instruction on how to preform some common tasks see the Quick Actions page.
Detailed documentation, licensing information, and much more can be found at
the MySQL web site. Many books are available which describe SQL in
detail. If you plan on doing much database development, it is recommended that you review
one or more of these.
Please note that Linux Web Host does not provide technical or development support
for MySQL applications.
|