22nd
OCT

The Visibooks Guide To MySQL Basics

Posted by GaQuay under Database

This tutorial helps students learn how to use the open-source MySQL database.

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
download



Password default: netbks.com

Add this page to your favorite Social Bookmarking websites
Del.icio.us! Reddit! digg:Java Garage Technorati! StumbleUpon! DZone!
Report Dead Link Please leave a comment to report dead links, so that someone else may update new links.
If you enjoyed this post, make sure you subscribe to my RSS feed!

Related Ebooks

Leave a Reply