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
Examples of SQL Statements
Below a few examples are provided to give you an idea of what an SQL statement looks like.
Though they have a specific structure and can perform complex operations, SQL
commands are fairly easy to understand.
For example,
CREATE TABLE Phonebook (
Id char(5),
Name char(50),
Telephone char(11)
);
creates a new table in your database named Phonebook that has three
fields, Id, Name, and Telephone, which are
characters strings of length 5, 50 , and 11, respectively.
The statement
INSERT INTO Phonebook (Id, Name, Telephone)
VALUES (‘AAAAA’, ‘Joe Smith’, ‘800-555-1212’);
adds the data into the named fields as a new record of the Phonebook
table in your database.
The statement
SELECT Name, Telephone
FROM Phonebook
WHERE Id = ‘AAAAA’;
searches the table Phonebook and finds the Name and Telephone
number of the customer whose Id is equal to ‘AAAAA’.
These are, of course, simple statements. Much more complicated databases and queries
can be written using SQL, all of which are supported by MySQL.
Much of your database management will be done through the MySQL Control Panel provided
in your account administration pages and not by typing in commands such as above. Though
not needed, a working undrstanding of how to read and write SQL statements is of great
help. There are many books and web sites which teach SQL and have many
more examples. If you plan on doing much database development, it is recommended
that you review them.
|