The Visilearn Guide to MySQL Basics
This tutorial helps students learn how to use the open-source MySQL database. Purchase and use it in one of two formats:
|
Online Tutorial
|
Printable PDF
|
License fee: $499 per school. View license terms.
Fax purchase orders to 208-279-5336.
Table of Contents:
Getting Started
- Install MySQL on a Linux computer
- Start MySQL
- Create a new database
- Create a table
- Create a record
- Run a query
Administering Databases
- Restart MySQL
- Back up a database
- Delete a table
- Delete a database
- Restore a database
Working with Tables
- Alter tables
- Update records
- Delete records
Running Queries
- Sort query results
- Add query criteria
Securing a Database
- Add a local user
- Add a remote user
- Remove a user
- Restrict a user
Web-enabling Databases
- Perform a query using PERL
- Join two tables using PERL
- Create a CGI script
- Write a query in a CGI script
