MySQL Pocket Reference: SQL Functions and Utilities, 2/e

George Reese

  • 出版商: O'Reilly
  • 出版日期: 2007-08-21
  • 定價: $525
  • 售價: 9.5$499
  • 語言: 英文
  • 頁數: 134
  • 裝訂: Paperback
  • ISBN: 0596514263
  • ISBN-13: 9780596514266
  • 相關分類: MySQLSQL
  • 立即出貨 (庫存=1)

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

商品描述

Description

To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.

Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:
  • How to configure MySQL, such as setting the root password
  • MySQL data types, including numerics, strings, dates, and complex types
  • SQL syntax, commands, data types, operators, and functions
  • Arithmetic, comparison and logical operators
  • Aggregate and general functions
  • Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers
You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.

Table of Contents

Introduction 

     MySQL 5
               Views 

               Triggers 

               Stored Procedures 

               Cursors 

               New Storage Engines 

               Database Events 

     Setup 

               Downloading MySQL 

               Configuration 

               Startup 

               Set the Root Password 

               Replication 

     Command-Line Tools 

     Data Types 

               Numerics 

               Strings 

               Dates 

               Complex Types 

     SQL 

               Case Sensitivity 

               Literals 

               Identifiers 

               Comments 

               Commands 

               Transaction Rules 

     Operators 

               Rules of Precedence 

               Arithmetic Operators 

               Comparison Operators 

               Logical Operators 

     Functions 

               Aggregate Functions 

               General Functions 

     Storage Engines 

     Stored Procedures and Functions 

               Parameters 

               Logic 

               Handlers and Conditions 

     Triggers 

Index

 

商品描述(中文翻譯)

描述

為了幫助您在工作中更高效,這本便攜式口袋參考書將立即提醒您如何使用重要的MySQL函數,特別是與LAMP開源基礎架構的關鍵部分相結合。這個功能強大的數據庫系統功能如此豐富,以至於沒有管理員或程序員能夠熟悉所有功能。《MySQL口袋參考》是一個理想的工作伴侶,組織良好,幫助您快速找到並適應所需的語句。

本版更新了這個流行數據庫的最新版本,包括對MySQL 5.0和5.1添加的許多複雜功能的介紹,其中包括一個專門介紹存儲過程和觸發器的部分。在簡短介紹安裝和初始設置之後,本書解釋了以下內容:
- 如何配置MySQL,例如設置根密碼
- MySQL數據類型,包括數字、字符串、日期和複雜類型
- SQL語法、命令、數據類型、運算符和函數
- 算術、比較和邏輯運算符
- 聚合和通用函數
- 存儲過程和觸發器,包括過程定義、過程調用、過程管理、游標和觸發器

當您忙於工作時,沒有時間停下來翻閱詳盡的參考資料。這本便攜且價格實惠的指南小巧到可以放進口袋,為您提供方便的參考,隨時隨地查閱。當您遇到問題並需要快速解決方案時,《MySQL口袋參考》是您想要擁有的書籍。

目錄

- 簡介
- MySQL 5
- 檢視
- 觸發器
- 存儲過程
- 游標
- 新的存儲引擎
- 數據庫事件
- 安裝設置
- 下載MySQL
- 配置
- 啟動
- 設置根密碼
- 複製
- 命令行工具
- 數據類型
- 數字
- 字符串
- 日期
- 複雜類型
- SQL
- 大小寫敏感性