Ebook: The definitive guide to MySQL 5
Author: Michael Kofler
- Genre: Computers // Databases
- Series: The expert's voice in Open Source
- Year: 2005
- Publisher: Apress
- Edition: 3
- Language: English
- pdf
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.
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.
Content:
Front Matter....Pages i-xxxi
Front Matter....Pages 1-1
What Is MySQL?....Pages 3-16
The Test Environment....Pages 17-45
Introductory Example (An Opinion Poll with PHP)....Pages 47-58
Front Matter....Pages 59-59
mysql, mysqladmin, and mysqldump....Pages 61-70
MySQL Administrator and MySQL Query Browser....Pages 71-85
phpMyAdmin....Pages 87-116
Microsoft Office, OpenOffice/StarOffice....Pages 117-134
Front Matter....Pages 135-135
Database Design....Pages 137-187
An Introduction to SQL....Pages 189-216
SQL Recipes....Pages 217-261
Access Administration and Security....Pages 263-297
GIS Functions....Pages 299-315
Stored Procedures and Triggers....Pages 317-343
Administration and Server Configuration....Pages 345-399
Front Matter....Pages 401-401
PHP....Pages 403-479
Perl....Pages 481-505
Java (JDBC and Connector/J)....Pages 507-525
C....Pages 527-544
Visual Basic 6/VBA....Pages 545-572
Visual Basic .NET and C#....Pages 573-595
Front Matter....Pages 597-597
SQL Reference....Pages 599-666
MySQL Tools and Options....Pages 667-691
API Reference....Pages 693-720
Back Matter....Pages 721-748
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.
Content:
Front Matter....Pages i-xxxi
Front Matter....Pages 1-1
What Is MySQL?....Pages 3-16
The Test Environment....Pages 17-45
Introductory Example (An Opinion Poll with PHP)....Pages 47-58
Front Matter....Pages 59-59
mysql, mysqladmin, and mysqldump....Pages 61-70
MySQL Administrator and MySQL Query Browser....Pages 71-85
phpMyAdmin....Pages 87-116
Microsoft Office, OpenOffice/StarOffice....Pages 117-134
Front Matter....Pages 135-135
Database Design....Pages 137-187
An Introduction to SQL....Pages 189-216
SQL Recipes....Pages 217-261
Access Administration and Security....Pages 263-297
GIS Functions....Pages 299-315
Stored Procedures and Triggers....Pages 317-343
Administration and Server Configuration....Pages 345-399
Front Matter....Pages 401-401
PHP....Pages 403-479
Perl....Pages 481-505
Java (JDBC and Connector/J)....Pages 507-525
C....Pages 527-544
Visual Basic 6/VBA....Pages 545-572
Visual Basic .NET and C#....Pages 573-595
Front Matter....Pages 597-597
SQL Reference....Pages 599-666
MySQL Tools and Options....Pages 667-691
API Reference....Pages 693-720
Back Matter....Pages 721-748
....