Managing & Using MySQL, 2/e

Tim King, George Reese, Randy Yarger, Hugh E. Williams, Randy Jay Yarger

  • 出版商: O'Reilly
  • 定價: $1,400
  • 售價: 9.0$1,260
  • 語言: 英文
  • 頁數: 442
  • 裝訂: Paperback
  • ISBN: 0596002114
  • ISBN-13: 9780596002114
  • 相關分類: MySQLSQL
  • 立即出貨

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

商品描述

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.

商品描述(中文翻譯)

MySQL是一個受歡迎且強大的開源數據庫產品,支持Linux和Unix系統上的SQL的關鍵子集。MySQL對非營利用途是免費的,商業用途則需要支付一小筆費用。與商業數據庫不同,MySQL價格實惠且易於使用。本書介紹了SQL和關聯數據庫理論。如果您計劃使用MySQL來構建網站或其他Linux或Unix應用程序,本書將教您如何做到這一點,並且在您理解基礎知識後,它將作為一本參考書仍然有用。書中包含了豐富的教程材料和示例。

本書包含了您充分利用這個強大的數據庫管理系統所需的一切。它將引導您完成從安裝和配置到編程接口和數據庫管理的整個過程。第二版增加了一個大大增強的管理章節,其中包括有關管理工具、服務器配置、服務器啟動和關閉、日誌文件管理、數據庫備份和恢復以及數據庫管理和修復的信息。此外,一個新的安全章節描述了數據、服務器和客戶端-服務器安全,而一個關於擴展MySQL的章節則提供了MySQL內部的概述並描述了MySQL自定義函數的使用。

如果您熟悉C/C++、Java、Perl、PHP或Python,您可以編寫與MySQL數據庫交互的程序。此外,您還可以直接在HTML文件中嵌入查詢和更新,使網頁成為數據庫的界面。《管理和使用MySQL》包括了關於編程語言接口的章節,並且還包括了一個完整的參考部分,其中列出了每種語言的具體函數調用。

參考部分還包括了SQL語言的參考和MySQL系統變量、程序和工具的詳細信息。第二版新增了對內部MySQL表的參考,這對於那些希望在MySQL安全方面進行大量工作的人尤其有興趣。