Back to DFS's Workshop Page
Back to Agenda Page

MySQL Pages

Tutorial/Reference Material

MySQL Introduction
Connecting to the Server
Selecting Information
Maintaining the Database

Simple Sample Scripts

Baseball

List First Names (Unsorted)
List Surnames (Sorted Alphabetically)
List Full Names (Sorted Alphabetically by Surname)
List Surnames (Sorted in Descending Order)
Get Player Info Using a Text Box
Get Player Info Using a Select Box
List All Players & Info in an HTML Table
Sort All Players & Info on Any Field & Display in an HTML Table
List All Info (Sorted in Descending Order by Average and then Hits)

Authors and Their Works Using a Link Table

Who Authored This Work?
Get Works Coauthored by Specified Writers
Who Coauthored More than x Works?

N.B. The construction of the baseball database is discussed in the MySQL Introduction assuming you are using phpMyAdmin. Accessing the database is accomplished using PHP. If, for some strange reason, you will not install phpMyAdmin, you can construct the database using mysql directly.