Publisher: O'Reilly Media Released: April 2002 Pages: 448
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 you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security. |
-
Introduction -
Chapter 1 MySQL - Relational Databases
- The History of MySQL
- MySQL Design
- MySQL Features
- MySQL Applications
- What You Get
-
Chapter 2 Installation - Preparation
- Unix Installation
- Windows Installation
-
Chapter 3 SQL According to MySQL - SQL Basics
- Database Creation
- Table Management
- MySQL Data Types
- Indexing
- Managing Data
- Queries
- SQL Operators
- Advanced Features
-
Chapter 4 Database Administration - Configuration
- Server Startup and Shutdown
- Logging
- Backup
- Recovery
- Table Maintenance and Crash Recovery
-
MySQL Administration -
Chapter 5 Performance Tuning - An Approach to Performance Tuning
- Application Tuning
- Database Server Tuning
- Operating System/Hardware Tuning
-
Chapter 6 Security - Database Security
- System Security
- Application Security
-
Chapter 7 Database Design - Database Design Primer
- Normalization
- A Logical Data-Modeling Methodology
- Physical Database Design
-
MySQL Programming -
Chapter 8 Database Applications - Architecture
- Connections and Transactions
- Object/Relational Modeling
-
Chapter 9 Perl - Introduction to DBI
- DBI and CGI
- A General Model for Maintainable Perl Programs
-
Chapter 10 Python - DB-API
- Proprietary Operations
- Applied DB-API
-
Chapter 11 PHP - Introducing PHP
- Installing PHP
- Accessing the MySQL DBMS with PHP
- Securing User Data
- Managing Sessions
- Writing Data with PHP
- Using the HTML <form> Environment
- Where to Find Out More
-
Chapter 12 C API - API Overview
- The C API in Practice
- Advanced Issues
-
Chapter 13 Java - The JDBC API
- Simple Database Access
- Dynamic Database Access
- A Guest Book Servlet
-
Chapter 14 Extending MySQL - User-Defined Functions
- Alternative Character Sets
-
MySQL Reference -
Chapter 15 SQL Syntax for MySQL - Basic Syntax
- SQL Commands
-
Chapter 16 MySQL Data Types - Numeric Data Types
- String Data Types
- Date Data Types
- Complex Data Types
-
Chapter 17 Operators and Functions - Operators
- Functions
-
Chapter 18 MySQL PHP API Reference - Data Types
- Functions
-
Chapter 19 C Reference - Data Types
- Functions
-
Chapter 20 The Python DB-API - Module: MySQLdb
-
Colophon |
- Title:
- Managing & Using MySQL, 2nd Edition
- By:
- Tim King, George Reese, Randy Yarger, Hugh E. Williams
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- April 2002
- Ebook:
- June 2009
- Pages:
- 448
- Print ISBN:
- 978-0-596-00211-4
- | ISBN 10:
- 0-596-00211-4
- Ebook ISBN:
- 978-1-4493-9295-6
- | ISBN 10:
- 1-4493-9295-4
|
-
Tim King Tim King has been working with computers since the early 1980s, when he programmed games on his Commodore 64 computer and founded a computer club in his high school. He earned a bachelor's degree in computer science from the University of Minnesota Institute of Technology in 1991. While there, he taught Unix and vi classes and was the leader of a rag-tag group of vi devotees called the "VI Zombies." Presently, Tim is a software consultant in San Francisco, CA, specializing in database and web technologies. His favorite activity is snowboarding, but he also enjoys photography and reading. You can reach him at kingt@verio.com View Tim King's full profile page. -
George Reese George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as "The People's Court" and ESPN's "Up Close". The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis. View George Reese's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. Kingfishers The animals featured on the cover of Managing & Using MySQL 2nd Edition are kingfishers. This type of bird can be found all over the world, including North America, Europe, Africa, and New Zealand, with the greatest numbers being found in southeast Asia. There are over 80 species of kingfishers, which range in size from five to eighteen inches and which cover a broad spectrum of color. These typically long-billed birds pair for life and are considered to be very territorial. Their nests are long and tunnel-shaped, and are often found in exposed tree roots or water banks. Most kingfishers live along the banks of rivers or lakes, as the primary staple of their diet is fish. To catch its prey, a kingfisher will perch on a branch above water, watch for a fish, hover for a moment, and then dive headfirst into the water, grabbing the fish in its beak, and heading back up to the surface. The process takes about a third of a second. The kingfisher's diet also consists of spiders, insects, and small amphibians. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By Carl Malamud
April 1994
By Rael Dornfest, Tara Calishain, DJ Adams
June 2004
By Walter Glenn
April 2004
Ebook: $7.99
Print & Ebook: $10.95
Print: $9.95
|
Customer Reviews
6/6/2003 5.0Managing & Using MySQL, 2nd Edition Review 3/25/2003 3.0Managing & Using MySQL, 2nd Edition Review 3/4/2003 1.0Managing & Using MySQL, 2nd Edition Review 6/27/2002 4.0Managing & Using MySQL, 2nd Edition Review
|
|
|