Skip to main content
SpringerLink
Log in
Apress
Book cover

The Definitive Guide to MySQL 5

  • Book
  • © 2005

Overview

Authors:
  1. Michael Kofler
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • MySQL 5, due to be released in summer 2005, is slated to be the most significant release in the product’s history

  • The first book to offer in-depth instruction on the new features

  • Shows readers how to connect to MySQL via all of the major APIs, including PHP, Perl, Java, JSP, and C#/

  • Novice and intermediate database administrators are introduced to both MySQL’s key features, and crucial database management concepts by way of real-world examples such as discussion forums, online polls, and other data administration projects

  • 25k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 44.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 59.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (23 chapters)

  1. Front Matter

    Pages i-xxxi
    Download chapter PDF

  2. Introduction

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. What Is MySQL?

      Pages 3-16

    3. The Test Environment

      Pages 17-45

    4. Introductory Example (An Opinion Poll with PHP)

      Pages 47-58

  3. Administrative Tools and User Interfaces

    1. Front Matter

      Pages 59-59
      Download chapter PDF

    2. mysql, mysqladmin, and mysqldump

      Pages 61-70

    3. MySQL Administrator and MySQL Query Browser

      Pages 71-85

    4. phpMyAdmin

      Pages 87-116

    5. Microsoft Office, OpenOffice/StarOffice

      Pages 117-134

  4. Fundamentals

    1. Front Matter

      Pages 135-135
      Download chapter PDF

    2. Database Design

      Pages 137-187

    3. An Introduction to SQL

      Pages 189-216

    4. SQL Recipes

      Pages 217-261

    5. Access Administration and Security

      Pages 263-297

    6. GIS Functions

      Pages 299-315

    7. Stored Procedures and Triggers

      Pages 317-343

    8. Administration and Server Configuration

      Pages 345-399

  5. Programming

    1. Front Matter

      Pages 401-401
      Download chapter PDF

    2. PHP

      Pages 403-479
Back to top

Keywords

About this book

MySQL 5 is slated to be the most significant release in the products history. The Definitive Guide to MySQL 5, Third Edition is the newest revision of Michael Koflers popular book. This is the first book to offer in-depth instruction about the new features of the world's most popular open source database server. Updated to reflect changes in MySQL version 5, this book will expose you to MySQL's impressive array of new features: views, stored procedures, triggers, and spatial data types.

Whether you're a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.

About the author

Michael Kofler holds a Ph.D. in computer science from Graz Technical University in Austria. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic .NET, and Linux. Michael is the author of The Definitive Guide to MySQL 5, Third Edition and Definitive Guide to Excel VBA, Second Edition from Apress.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation