MySQL Cookbook 3rd Edition：数据库开发者和管理员解决方案

需积分: 10 183 浏览量更新于2024-07-21 收藏 4.05MB PDF 举报

"MySQL Cookbook 3rd Edition 是一本针对数据库开发者和管理员的解决方案集，由 Paul DuBois 编写。本书全面覆盖了 MySQL 的基础知识，适合初学者，同时介绍了最新的发展，以帮助高级用户深入理解并提升技能。书中包含了大量的技巧和实用的代码片段，提供了数百个实际操作示例和清晰的解释，对于那些没有足够时间或专业知识从零开始解决 MySQL 问题的专业人士来说尤其有价值。" 在《MySQL Cookbook》第三版中，读者将能够学习到： 1. 基础概念：了解 MySQL 数据库的基本结构，包括表的创建、数据类型、索引以及查询语言 SQL 的基础语法。 2. 数据库管理：如何进行数据备份、恢复、性能优化和安全设置，这些都是数据库管理员日常工作中必不可少的知识。 3. 高级特性：如触发器、存储过程、视图、事务处理和并发控制等，这些内容可以帮助开发者编写更复杂和高效的数据库应用。 4. 性能调优：如何通过查询优化、索引策略和服务器配置来提高 MySQL 数据库的运行速度，这对于高流量的 Web 应用至关重要。 5. 开发工具：推荐使用哪些工具进行数据库管理和开发，如 MySQL Workbench、phpMyAdmin 和 Navicat 等，并指导如何有效地使用它们。 6. 最新更新：本书涵盖了 MySQL 的最新版本特性，包括 NoSQL 集成、分区表、复制与集群解决方案等，确保读者掌握最新的技术趋势。 7. 实战案例：通过大量实例，读者可以快速解决实际遇到的问题，如数据导入导出、数据转换、错误排查等。 8. 最佳实践：书中包含了许多专家提示，帮助读者遵循最佳实践，避免常见陷阱，提升开发效率和数据库稳定性。 9. 社区支持：作者 Paul DuBois 在 MySQL 社区有深厚背景，书中的建议和解决方案往往基于社区的广泛经验和反馈。《MySQL Cookbook 3rd Edition》是一本实用且全面的指南，无论你是刚接触 MySQL 的新手，还是已经有一定经验的开发者，都能从中受益。通过这本书，你可以快速找到解决问题的方法，深化对 MySQL 的理解，并提升你的数据库技能。

What’s in This Book

It’s very likely when you use this book that you’re trying to develop an application but

are not sure how to implement certain pieces of it. In this case, you already know what

type of problem you want to solve; check the table of contents or the index for a recipe

that shows how to do what you want. Ideally, the recipe will be just what you had in

mind. Alternatively, you may be able to adapt a recipe for a similar problem to suit the

issue at hand. I explain the principles involved in developing each technique so that you

can modify it to fit the particular requirements of your own applications.

Another way to approach this book is to just read through it with no specific problem

in mind. This can give you a broader understanding of the things MySQL can do, so I

recommend that you page through the book occasionally. It’s a more effective tool if

you know the kinds of problems it addresses.

As you get into later chapters, you’ll find recipes that assume a knowledge of topics

covered in earlier chapters. This also applies within a chapter, where later sections often

use techniques discussed earlier in the chapter. If you jump into a chapter and find a

recipe that uses a technique with which you’re not familiar, check the table of contents

or the index to find where the technique is explained earlier. For example, if a recipe

sorts a query result using an ORDER BY clause that you don’t understand, turn to Chap‐

ter 7, which discusses various sorting methods and explains how they work.

Here’s a summary of each chapter to give you an overview of the book’s contents.

Chapter 1, Using the mysql Client Program, describes how to use the standard MySQL

command-line client. mysql is often the first or primary interface to MySQL that people

use, and it’s important to know how to exploit its capabilities. This program enables you

to issue queries and see their results interactively, so it’s good for quick experimentation.

You can also use it in batch mode to execute canned SQL scripts or send its output into

other programs. In addition, the chapter discusses other ways to use mysql, such as how

to make long lines more readable or generate output in various formats.

Chapter 2, Writing MySQL-Based Programs, demonstrates the essential elements of

MySQL programming: how to connect to the server, issue queries, retrieve the results,

and handle errors. It also discusses how to handle special characters and NULL values in

queries, how to write library files to encapsulate code for commonly used operations,

and various ways to gather the parameters needed for making connections to the server.

Chapter 3, Selecting Data from Tables, covers several aspects of the SELECT statement,

which is the primary vehicle for retrieving data from the MySQL server: specifying

which columns and rows you want to retrieve, dealing with NULL values, and selecting

one section of a query result. Later chapters cover some of these topics in more detail,

but this chapter provides an overview of the concepts on which they depend if you need

some introductory background on row selection or don’t yet know a lot about SQL.

xiv | Preface

Chapter 4, Table Management, covers table cloning, copying results into other tables,

using temporary tables, and checking or changing a table’s storage engine.

Chapter 5, Working with Strings, describes how to deal with string data. It covers char‐

acter sets and collations, string comparisons, dealing with case-sensitivity issues, pattern

matching, breaking apart and combining strings, and performing FULLTEXT searches.

Chapter 6, Working with Dates and Times, shows how to work with temporal data. It

describes MySQL’s date format and how to display date values in other formats. It also

covers how to use MySQL’s special TIMESTAMP data type, how to set the time zone, how

to convert between different temporal units, how to perform date arithmetic to compute

intervals or generate one date from another, and how to perform leap-year calculations.

Chapter 7, Sorting Query Results, describes how to put the rows of a query result in the

order you want. This includes specifying the sort direction, dealing with NULL values,

accounting for string case sensitivity, and sorting by dates or partial column values. It

also provides examples that show how to sort special kinds of values, such as domain

names, IP numbers, and ENUM values.

Chapter 8, Generating Summaries, shows techniques for assessing the general charac‐

teristics of a set of data, such as how many values it contains or its minimum, maximum,

and average values.

Chapter 9, Using Stored Routines, Triggers, and Scheduled Events, describes how to write

stored functions and procedures that are stored on the server side, triggers that activate

when tables are modified, and events that execute on a scheduled basis.

Chapter 10, Working with Metadata, discusses how to get information about the data

that a query returns, such as the number of rows or columns in the result, or the name

and data type of each column. It also shows how to ask MySQL what databases and

tables are available or determine the structure of a table.

Chapter 11, Importing and Exporting Data, describes how to transfer information be‐

tween MySQL and other programs. This includes how to use LOAD DATA, convert files

from one format to another, and determine table structure appropriate for a dataset.

Chapter 12, Validating and Reformatting Data, describes how to extract or rearrange

columns in datafiles, check and validate data, and rewrite values such as dates that often

come in a variety of formats.

Chapter 13, Generating and Using Sequences, discusses AUTO_INCREMENT columns,

MySQL’s mechanism for producing sequence numbers. It shows how to generate new

sequence values or determine the most recent value, how to resequence a column, and

how to use sequences to generate counters. It also shows how to use AUTO_INCREMENT

values to maintain a master-detail relationship between tables, including pitfalls to

avoid.

Preface | xv

Chapter 14, Using Joins and Subqueries, shows how to perform operations that select

rows from multiple tables. It demonstrates how to compare tables to find matches or

mismatches, produce master-detail lists and summaries, and enumerate many-to-many

relationships.

Chapter 15, Statistical Techniques, illustrates how to produce descriptive statistics, fre‐

quency distributions, regressions, and correlations. It also covers how to randomize a

set of rows or pick rows at random from the set.

Chapter 16, Handling Duplicates, discusses how to identify, count, and remove duplicate

rows—and how to prevent them from occurring in the first place.

Chapter 17, Performing Transactions, shows how to handle multiple SQL statements

that must execute together as a unit. It discusses how to control MySQL’s auto-commit

mode and how to commit or roll back transactions.

Chapter 18, Introduction to MySQL on the Web, gets you set up to write web-based

MySQL scripts. Web programming enables you to generate dynamic pages from data‐

base content or collect information for storage in your database. The chapter discusses

how to configure Apache to run Perl, Ruby, PHP, and Python scripts, and how to con‐

figure Tomcat to run Java scripts written using JSP notation.

Chapter 19, Generating Web Content from Query Results, shows how to use the query

results to generate various HTML structures such as paragraphs, lists, tables, hyperlinks,

and navigation indexes. It also describes how to store images into MySQL and retrieve

and display them later, and how to generate downloadable result sets.

Chapter 20, Processing Web Input with MySQL, discusses how to obtain input from

users over the Web and use it to create new database rows or as the basis for performing

searches. It deals heavily with form processing, including how to construct form ele‐

ments such as radio buttons, pop-up menus, or checkboxes, based on information con‐

tained in your database.

Chapter 21, Using MySQL-Based Web Session Management, describes how to write web

applications that remember information across multiple requests, using MySQL for

backing store. This is useful for collecting information in stages, or when you need to

make decisions based on prior user actions.

Chapter 22, Server Administration, is written for database administrators. It covers

server configuration, the plug-in interface, log management, server monitoring, and

making backups.

Chapter 23, Security, is another administrative chapter. It discusses user account man‐

agement, including creating accounts, setting passwords, and assigning privileges. It

also describes how to implement password policy, find and fix insecure accounts, and

expire or unexpire passwords.

xvi | Preface

MySQL APIs Used in This Book

MySQL programming interfaces exist for many languages, including C, C++, Eiffel, Go,

Java, Perl, PHP, Python, Ruby, and Tcl. Given this fact, writing a MySQL cookbook

presents an author with a challenge. The book should provide recipes for doing many

interesting and useful things with MySQL, but which API or APIs should the book use?

Showing an implementation of every recipe in every language results either in covering

very few recipes or in a very, very large book! It also results in redundancies when

implementations in different languages bear a strong resemblance to each other. On the

other hand, it’s worthwhile taking advantage of multiple languages, because one often

is more suitable than another for solving a particular problem.

To resolve this dilemma, I’ve chosen a small number of APIs to write the recipes in this

book. This makes its scope manageable while permitting latitude to choose from mul‐

tiple APIs:

•

The Perl and Ruby DBI modules

•

PHP, using the PDO extension

•

Python, using the MySQL Connector/Python driver for the DB API

•

Java, using the MySQL Connector/J driver for the JDBC interface

Why these languages? Perl and PHP were easy to pick. Perl is a widely used language

that became so based on certain strengths such as its text-processing capabilities. In

addition, it’s very popular for writing MySQL programs. Ruby has an easy-to-use

database-access module modeled after the Perl module. PHP is widely deployed, espe‐

cially on the Web. One of PHP’s strengths is the ease with which you can use it to access

databases, making it a natural choice for MySQL scripting. Python and Java are perhaps

not as popular as Perl or PHP for MySQL programming, but each has a significant

number of followers. In the Java community in particular, MySQL has a strong following

among developers who use JavaServer Pages (JSP) technology to build database-backed

web applications.

I believe these languages taken together reflect pretty well the majority of the existing

user base of MySQL programmers. If you prefer some language not shown here, be sure

to pay careful attention to Chapter 2, to familiarize yourself with the book’s primary

APIs. Knowing how to perform database operations with the programming interfaces

used here will help you translate recipes for other languages.

Version and Platform Notes

Development of the code in this book took place under MySQL 5.5, 5.6, and 5.7. Because

new features are added to MySQL on a regular basis, some examples will not work under

older versions. For example, MySQL 5.5 introduces authentication plug-ins, and

Preface | xvii

剩余865页未读，继续阅读

纯洁的好人

粉丝: 2
资源: 137

MySQL Cookbook 3rd Edition：数据库开发者和管理员解决方案

高性能mysql 第三版 高清 pdf

MySQL Cookbook(第2版) 中文版.pdf

高性能mysql第三版word+pdf版电子文件

758820 mysql 8 cookbook(中文版)

近五年的MySQL书记

html,css,javascript,node.js,Mysql数据库的参考文献

列举一些关于mysql的外文参考文献

apache maven cookbook 下载

boost asio cookbook pdf

计算机毕业设计参考文献springboot以及mysql相关的文献

最新资源

高性能mysql 第三版高清 pdf