MySQL: The Complete Reference

Vikram Vaswani

  • 出版商: McGraw-Hill Education
  • 出版日期: 2004-01-08
  • 售價: $1,640
  • 貴賓價: 9.5$1,558
  • 語言: 英文
  • 頁數: 544
  • 裝訂: Paperback
  • ISBN: 0072224770
  • ISBN-13: 9780072224771
  • 相關分類: MySQLSQL
  • 已過版




Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.


The Most Authoritative Resource on the MySQL Database Available! Reviewed by the MySQL Development Team.

Get the most out of the MySQL database server--today’s most popular open source database--with help from this definitive guide. Take advantage of MySQL’s cross-platform support, independent storage engines, advanced permissions and security system, query caching, full-text indexing and searching, and much more. Reviewed by the MySQL database development team, MySQL: The Complete Reference explains in full detail how to use this customizable RDMS to support robust, reliable, mission-critical applications.

  • Install, configure, and test a MySQL database on Linux/UNIX or Windows
  • Use MySQL data types, statements, operators, and functions
  • Manage databases and tables with the Data Definition Language (DDL)
  • Add, delete, and query records using the Data Manipulation Language (DML)
  • Take advantage of transactional support
  • Implement MySQL’s five-tiered access control and privilege system
  • Handle database optimization, backup, recovery, and replication
  • Create applications in C, C++, Perl, Java, PHP, and other languages

Vikram Vaswani is the founder and CEO of Melonfire, a company specializing in Web design, development, and content creation for a variety of clients. He has also written extensively on open source technologies, including MySQL, Perl, Python, and PHP.


   Part I: Installation
    1: Introduction to Databases
    2: A Technical Tour of MySQL
    3: MySQL Installation and Configuration

   Part II: Usage
    4: SQL Basics
    5: MySQL Data Types
    6: MySQL Operators
    7: MySQL Functions
    8: Working with Databases and Tables
    9: Working with Data
    10: Joins
    11: Subqueries
    12: Transactions

   Part III: Administration
    13: Administration and Configuration
    14: Security, Access Control, and Privileges
    15: Maintenance, Backup, and Recovery
    16: Performance Optimization
    17: MySQL Replication

   Part IV: Development
    18: The MySQL APIs
    19: MySQL and C
    20: MySQL and Perl
    21: MySQL and PHP