Support Manual

MySQL Overview

SQL stands for Structured Query Language. It is the most common language used for accessing a database, and has been in use for many years. 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 allow you 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.

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.

For step by step instruction on how to perform 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.

Hosting Connecticut, LLC does not provide technical support for using MySQL, however you will find loads of useful information as well as additional resources that will assist you within the following links.

 

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.