MySQL: The Complete Reference

Vikram Vaswani

MySQL: The Complete Reference
  • 出版商: McGraw-Hill Education
  • 出版日期: 2004-01-08
  • 售價: $2,110
  • 貴賓價: 9.5 折 $2,005
  • 語言: 英文
  • 頁數: 544
  • 裝訂: Paperback
  • ISBN: 0072224770
  • ISBN-13: 9780072224771
  • 相關分類: MySQL、SQL

    • 已過版

買這商品的人也買了...

相關主題

商品描述

Description            

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.

Back Cover            

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.

Contents           

   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

類似商品