The Visibooks Guide To MySQL Basics

22nd
OCT

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

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

Contribution Progress Meter: 10.00USD (6.6%) of $150$

Thank You! so much for your contribution! We really appreciate it!