Download Free Computer Ebooks - NET BOOKS

The Visibooks Guide To MySQL Basics

Posted by IDM 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

Login [This hidden content is only available for our VIP member]. Become VIP Member NOW

Password default : netbks.us

Donate to become VIP member

Related Ebooks

• Jet Profiler for MySQL v1.0.8-iNViSiBLE [full]
• Richardson Software RazorSQL v5.1.6
• MySQL Database CMA 010-002 training
• CBT Nuggets – MySQL Database CMA 010-002 (2010)
• Beginning Oracle SQL
• CBT Nuggets MySQL CMA Database Administrator Associate DVD
• Mastering phpMyAdmin 2.11 for Effective MySQL Management
• Database Design Manual: using MySQL for Windows
• SQL for Microsoft Access (Wordware Applications Library)
• Microsoft Access 2010 Training Tutorial Course

Leave a Reply

Name (required)

Mail (will not be published) (required)