En savoir plus
Zusatztext 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. Informationen zum Autor 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 Klappentext 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 o...
Table des matières
Preface
Part I: Introduction
Chapter 1: MySQL
Chapter 2: Installation
Chapter 3: SQL According to MySQL
Chapter 4: Database Administration
Part II: MySQL Administration
Chapter 5: Performance Tuning
Chapter 6: Security
Chapter 7: Database Design
Part III: MySQL Programming
Chapter 8: Database Applications
Chapter 9: Perl
Chapter 10: Python
Chapter 11: PHP
Chapter 12: C API
Chapter 13: Java
Chapter 14: Extending MySQL
Part IV: MySQL Reference
Chapter 15: SQL Syntax for MySQL
Chapter 16: MySQL Data Types
Chapter 17: Operators and Functions
Chapter 18: MySQL PHP API Reference
Chapter 19: C Reference
Chapter 20: The Python DB-API
Colophon
