Managing and Using MySQL Open Source SQL Databases for Managing Information and Web Sites

Name: Managing and Using MySQL Open Source SQL Databases for Managing Information and Web Sites
Price: 4.91 USD
Availability: InStock
ISBN: 9780596002114

ISBN-10: 0596002114

ISBN-13: 9780596002114

Edition: 2nd 2002

Authors: Tim King, George Reese, Randy Yarger, Hugh E. Williams

List price: $39.99

30 day, 100% satisfaction guarantee!

Buy new: $28.50

Marketplace

5 new & used from $4.91

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes…

Book details

List price: $39.99
Edition: 2nd
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 5/14/2002
Binding: Paperback
Pages: 444
Size: 7.00" wide x 9.19" long x 1.07" tall
Weight: 1.584
Language: English

Tim King

Cara Baker, Specialist Registrar atnbsp;University College London#60;/p#62;#60;p#62;James Teo, Specialist Registrar atnbsp;University College London#60;/p#62;#60;p#62;George Reese, Specialist Registrar atnbsp;the Royal Free Hospital,nbsp;London#60;/p#62;

Hugh E. Williams is a software design engineer at Microsoft's WindowsLive Search in Redmond, WA. Previously, he was the AssociateProfessor in Information Retrieval at RMIT University in Melbourne,Australia. He's published over 70 research papers and holds around 10patents, mostly in the search engine area. When not at work Hughlikes to hang out with his family, exercise, watch Richmond playfooty, and learn about baseball. Hugh has a PhD from RMIT University.His home page is http://hughwilliams.com .



Preface



Introduction



MySQL


Relational Databases


The History of MySQL


MySQL Design


MySQL Features


MySQL Applications


What You Get



Installation


Preparation


Unix Installation


Windows Installation



SQL According to MySQL


SQL Basics


Database Creation


Table Management


MySQL Data Types


Indexing


Managing Data


Queries


SQL Operators


Advanced Features



Database Administration


Configuration


Server Startup and Shutdown


Logging


Backup


Recovery


Table Maintenance and Crash Recovery



MySQL Administration



Performance Tuning


An Approach to Performance Tuning


Application Tuning


Database Server Tuning


Operating System/Hardware Tuning



Security


Database Security


System Security


Application Security



Database Design


Database Design Primer


Normalization


A Logical Data-Modeling Methodology


Physical Database Design



MySQL Programming



Database Applications


Architecture


Connections and Transactions


Object/Relational Modeling



Perl


Introduction to DBI


DBI and CGI


A General Model for Maintainable Perl Programs



Python


DB-API


Proprietary Operations


Applied DB-API



PHP


Introducing PHP


Installing PHP


Accessing the MySQL DBMS with PHP


Securing User Data


Managing Sessions


Writing Data with PHP


Using the HTML [left angle bracket]form[right angle bracket] Environment


Where to Find Out More



CAPI


API Overview


The C API in Practice


Advanced Issues



Java


The JDBC API


Simple Database Access


Dynamic Database Access


A Guest Book Servlet



Extending MySQL


User-Defined Functions


Alternative Character Sets



MySQL Reference



SQL Syntax for MySQL


Basic Syntax


SQL Commands



MySQL Data Types


Numeric Data Types


String Data Types


Date Data Types


Complex Data Types



Operators and Functions


Operators


Functions



MySQL PHP API Reference


Data Types


Functions



C Reference


Data types


Functions



The Python DB-API


Module: MySQLdb


Index