Custom Search

Available Categories

Adobe Macromedia Programming SQL Server Administration Networking Microsoft Products Mac OS Linux systems Mobile devices XML Certification Misc

Available Tutorials

MySQL pocket reference SQL Bible Oracle Sql tuning Database design for mere mortals MySQL Postgresql Microsoft SQL Server 2000 Mastering Oracle SQL Oracle PL SQL Language Pocket Reference Oracle DBA guide to data warehousing and star schemas Administrator's guide to sql server 2005 Sql bible

| More

MySQL

Please select a chapter from the "Contents" menu at the very bottom of the page.

MySQL

Part I: General MySQL Use

Chapter 1. Getting Started with MySQL and SQL

How MySQL Can Help You

A Sample Database

Basic Database Terminology

A MySQL Tutorial

Tips for Interacting with mysql

Chapter 2. Working with Data in MySQL

MySQL Data Types

MySQL Column Types

Working with Sequences

Character Set Support

Choosing Column Types

Expression Evaluation and Type Conversion

Chapter 3. MySQL SQL Syntax and Use

MySQL Naming Rules

Selecting, Creating, Dropping, and Altering Databases

Creating, Dropping, Indexing, and Altering Tables

Getting Information about Databases and Tables

Retrieving Records from Multiple Tables

Multiple-Table Deletes and Updates

Performing Transactions

Foreign Keys and Referential Integrity

Using FULLTEXT Searches

Writing Comments

Features That MySQL Does Not Support

Chapter 4. Query Optimization

The MySQL Query Optimizer

Column Type Choices and Query Efficiency

Loading Data Efficiently

Scheduling and Locking Issues

Optimization for Administrators

Part II: Using MySQL Programming Interfaces

Chapter 5. Introduction to MySQL Programming

Why Write Your Own MySQL Programs?

APIs Available for MySQL

Choosing an API

Chapter 6. The MySQL C API

General Procedure for Building Client Programs

Client 1?Connecting to the Server

Client 2?Adding Error Checking

Client 3?Getting Connection Parameters at Runtime

Processing Queries

Client 4?An Interactive Query Program

Writing Clients That Include SSL Support

Using the Embedded Server Library

Miscellaneous Topics

Chapter 7. The Perl DBI API

Perl Script Characteristics

Perl DBI Overview

Putting DBI to Work

Using DBI in Web Applications

Chapter 8. The PHP API

Putting PHP to Work

Part III: MySQL Administration

Chapter 9. Introduction to MySQL Administration

Overview of Administrative Duties

General Administration

Database Repair and Maintenance

Chapter 10. The MySQL Data Directory

Location of the Data Directory

Structure of the Data Directory

Relocating Data Directory Contents

Chapter 11. General MySQL Administration

Securing a New MySQL Installation

Arranging for MySQL Server Startup and Shutdown

Managing MySQL User Accounts

Maintaining Log Files

Additional Server Configuration Topics

Running Multiple Servers

Setting Up Replication Servers

Chapter 12. Security

Internal Security: Preventing Unauthorized File System Access

External Security: Preventing Unauthorized Network Access

Setting Up Secure Connections

Chapter 13. Database Backups, Maintenance, and Repair

Coordinating with the Server

Preparing for Disaster

Table Repair and Data Recovery

Part IV: Appendixes

Appendix A. Obtaining and Installing Software

Obtaining the sampdb Sample Database Distribution

Obtaining MySQL and Related Software

Installing MySQL on UNIX

Installing MySQL on Windows

Appendix B. Column Type Reference

Date and Time Types

Appendix C. Operator and Function Reference

Appendix D. SQL Syntax Reference

Appendix E. MySQL Program Reference

Specifying Program Options

'myisamchk' and 'isamchk'

'myisampack' and 'pack_isam'

'mysql_install_db'

Appendix F. C API Reference

Compiling and Linking

C API Data Types

C API Functions

Appendix G. Perl DBI API Reference

Writing Scripts

DBI Utility Functions

DBI Environment Variables

Appendix H. PHP API Reference

Writing PHP Scripts

Appendix I. Internet Service Providers

Getting Ready to Shop for an ISP

Assessing an ISP?General Considerations

Assessing an ISP?MySQL-Specific Considerations

| More

Remember the name: eTutorials.org. Copyright eTutorials.org 2008-2010. All rights reserved.