Skip to content

Definitive Guide to MySQL 5

Best in textbook rentals since 2012!

ISBN-10: 1590595351

ISBN-13: 9781590595350

Edition: 3rd 2005

Authors: Michael Kofler, David Kramer

List price: $59.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


MySQL 5 is slated to be the most significant release in the product's history. "The Definitive Guide to MySQL 5, Third Edition, is the newest revision of Michael Kofler's 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…    
Customers also bought

Book details

List price: $59.99
Edition: 3rd
Copyright year: 2005
Publisher: Apress L. P.
Publication date: 2/2/2006
Binding: Paperback
Pages: 784
Size: 7.50" wide x 9.00" long x 1.56" tall
Weight: 3.212

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.

About the Author
About the Translator
What Is MySQL?
What Is a Database?
Limitations of MySQL
MySQL Version Numbers
MySQL Licensing
Alternatives to MySQL
The Test Environment
Windows or Unix/Linux?
Installation Under Windows
Installation Under SUSE Linux 9.3
Installation Under Red Hat Enterprise Linux 4
Compiling the MySQL Developer Version (Linux)
Configuring Apache
Configuring PHP
Configuring MySQL
Introductory Example (An Opinion Poll with PHP)
Database Development
The Questionnaire
Questionnaire Evaluation and Displaying Results
Ideas for Improvements
Administrative Tools and User Interfaces
mysql, mysqladmin, and mysqldump
MySQL Administrator and MySQL Query Browser
Establishing a Connection
MySQL Administrator
MySQL Query Browser
Installation and Configuration
User Management, Securing MySQL
Creating and Editing Databases
Viewing, Inserting, and Editing Data
Executing SQL Commands
Import and Export
Server Administration
Auxiliary Functions
Microsoft Office, OpenOffice/StarOffice
Installing Connector/ODBC
Microsoft Access
Microsoft Excel
Connector/J Installation
OpenOffice/StarOffice Base
OpenOffice/StarOffice Data Source View
Database Design
Further Reading
Table Types
MySQL Data Types
Tips and Tricks on Database Design
Normalization Rules
Managing Hierarchies
Primary and Foreign Keys
Example Database mylibrary (Library Management)
Example Database myforum (Discussion Group)
Example Database Exceptions (Special Cases)
An Introduction to SQL
Simple Queries (SELECT)
Sorting Records (ORDER BY)
Selecting Data Records (WHERE, HAVING)
Linking Data from Several Tables
Uniting Query Results
Grouped Queries, Aggregate Functions
Altering Data(INSERT, UPDATE, and DELETE)
Creating New Tables, Databases, and Indexes
SQL Recipes
Character Strings
Date and Time
ENUMs and SETs
Variables and Conditionals (IF, CASE)
Copying Data from One Table to Another
Pivot Tables
Ensuring the Integrity of Data
Tracking Down Duplicates
Bringing a Table into Normal Form
Processing the First or Last n Records
Selecting Random Records
Full-Text Search
Access Administration and Security
First Aid
The Internal Workings of the Access System
Tools for Setting Access Privileges
Secure Password Authentication Since MySQL 4.1
Problems with Establishing a Connection
System Security
GIS Functions
GIS Data Formats
MySQL's GIS Implementation
SQL Examples (the Database glacier)
SQL Examples (the Database opengeodb)
Stored Procedures and Triggers
Why Stored Procedures? Why Triggers?
Hello, SP World!
SP Implementation
SP Administration
SP Syntax and Language Elements
SP Examples
Administration and Server Configuration
First Steps
Database Migration
Importing and Exporting Text Files
Administration of MyISAM Tables
Administration of InnoDB Tables
Server Tuning
ISP Database Administration
mysql Functions
mysqli Classes, Methods, and Properties
Outsourcing Database Functions into a Class
Displaying a SELECT Result As a Table
Character Strings, Dates, Times, BLOBs, and NULL
Inserting Linked Data Records
Processing Input from Forms
Pagewise Representation of Search Results
Managing Hierarchical Data
Speed Optimization
Binary Data (BLOBs) and Images
Stored Procedures
SP Administrator
Programming Techniques
Example: Deleting Invalid Data Records (mylibrary)
CGI Example: Library Management (mylibrary)
CGI Unicode Example
Java (JDBC and Connector/J)
Programming Techniques
The C API (libmysqlclient)
Hello, World!
Establishing the Connection
Executing SQL Commands
Working with Binary Data and Special Characters
Error Handling
Visual Basic 6/VBA
Fundamentals and Terminology
Connector/ODBC Options
ADO Programming and Visual Basic/VBA
Establishing the Connection
Converter: Microsoft SQL Server to MySQL
Visual Basic .NET and C#
Communication Between ADO.NET and MySQL
Programming Techniques
Example: Storing New Titles in mylibrary
Example: Storing an Image File in a BLOB and Then Reading It
SQL Reference
Variables and Constants
MySQL Data Types
Command Overview (Thematic)
Command Reference (Alphabetical)
Function Reference
GIS Data Types and Functions
Language Elements for Stored Procedures and Triggers
MySQL Tools and Options
Common Options and Configuration Files
mysqld (Server)
mysqld_safe (Server Start)
mysql_install_db (New Installation of the mysql Database)
mysql_fix_privileges (Updating the mysql Database)
mysql_fix_extensions (Renaming MyISAM Files)
mysql (SQL Command Interpreter)
mysqladmin (Administration)
mysqldump (Backup/Export)
mysqlimport (Text Import, Bulk Import)
mysqlshow (Displaying Information)
myisamchk (Repairing MyISAM Files)
myisampack (Compressing MyISAM Files)
API Reference
PHP API (mysql Interface)
PHP-API (mysqli Interface)
Perl DBI
JDBC (Connector/J)
ADO.NET (Connector/Net)
The Files for this Book
Trying Out the Example Programs
Updates, Errata, Links, Discussion Forum