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.

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.

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.â€

Detailed documentation, licensing information, and much more can be found at the MySQL web site. Many books are available which describe SQL in detail (see References below). If you plan on doing much database development, it is recommended that you review one or more of these.

Please note that Web Site Source, Inc. does not provide technical or development support for MySQL applications.

References

MySQL and mSQL
Randy Jay Yarge, George Reese, and Tim King
O'Reilly & Associates
ISBN 1565924347

The Practical SQL Handbook: Using Structured Query Language
Judith S. Bowman, Sandra L. Emerson and Marcy Darnovsky
Addison-Wesley
ISBN 0201626233

Understanding SQL
Martin Gruber
Sybex
ISBN 0895886448

Teach Yourself Sql in 21 Days
Ryan K. Stephens (Editor), Ronald R. Plew, Bryan Morgan, jeff Perkins
Sams Publishing
ISBN 0672311100

Be sure tocheck for the most current edition.

Web Sites

The MySQL site has an SQL reference and lots of information about MySQL in particular.

An SQL tutorial is available on the net at http://www.geocities.com/SiliconValley/Vista/2207/sql1.html

Newgroups

There are various newsgroups under the comp.database group which deal with databases. Always a good place to start.

Mailing Lists

The MySQL site lists in their documentation page a number of mailing lists concerning MySQL and SQL.

http://www.mysql.com/

FAQ's

How do I get started?

1. The following information is needed to create a MySQL Database.
1.Database name
2.Username to use for accessing the database
3.Password
(Username and password can be same as login.)

Setup your MySQL Database through your control panel. Just click on MySQL.

2.Once it's created, from your ssh prompt you type the following command line to access your database:

/usr/local/mysql/bin/mysql dbname -u username -ppassword
(no space between the -p and the password)

You can also access your MySQL Database from the Web using programming languages such as Perl and PHP.

How do I work with a MySQL database using PHP?

1.To merely display the information in your database without the use of a form to call a php script you simply create your HTML document as you would any other web page but instead of the extension of .htm or .html you need to name the file with the extension .phtml. Then within the document itself the section that you'd like to be the PHP code, you begin it with . For instance:

These are the products I sell:

mysql_connect(localhost, username, password);
$result = mysql(mydatabase, "select * from products");
$num = mysql_numrows($result);
$i = 0;

while($i < $num) {
echo "n";
echo "nnn";
echo "n";
$i++;}
?>

n";
echo mysql_result($result,$i,"prodid");
echo "

";
echo mysql_result($result,$i,"name");
echo "

";
echo mysql_result($result,$i,"price");
echo "

Thus having the loop in the php program create a table with the products listed. NOTE your username and password for the database are not written in the file when it's displayed on the Internet so users viewing the source of your webpage will not see your password.

2.When using a CGI script to pull information from a form which has been submitted by a browser you must have the first line of the script have this command on it (Much like perl scripts):

#!/usr/local/bin/php

How do I connect my Access DB with MySQL Database?

Connecting MS Access to a MySQL database

-- You will first need to contact support to request that we give you access to MySQL remotely, e.g., ODBC.

ON LOCAL PC:
1) Download and Install MyODBC 2.50.19 (or most current version) on local
Win95 machine with MS Access installed
--can download at: http://www.mysql.com/download.html

2) Fill in the following settings:
Windows DNS Name: You can choose the names, must be unique
Server: This is your domain name or IP address
MySQL Database Name: The name of your MySQL database
User: Your MySQL username
Password: Your MySQL password
Port: leave blank for default (3306(
Options; Select "Return Matching Rows"

3) To Link a Table
a) File...Get External Data...Link Tables
b) Under 'Files of Type:', select "ODBC Database"
c) Select Machine Data Source Tab, and select the appropriate Data Source
Name
d) Select the tables(s) to link

Article ID: 1022, Created: March 24, 2011 at 9:02 AM, Modified: April 8, 2011 at 10:18 AM

MySQL

Add Feedback

Was this article helpful?

Share this article