MySQL与JSON实战指南：编程入门

需积分: 10 184 浏览量更新于2024-07-18 收藏 6.36MB PDF 举报

"MySQL and JSON: A Practical Programming Guide" 是一本由 Dave Stokes 撰写，Frédéric Descamps 技术编辑的书籍，旨在帮助读者掌握如何在MySQL数据库中使用JavaScript Object Notation (JSON)。这本书是为那些希望快速上手MySQL与JSON集成的开发者准备的，详细介绍了相关的工具和函数，所有内容都基于最新的MySQL功能。 MySQL是世界上最受欢迎的关系型数据库管理系统之一，而JSON则是一种轻量级的数据交换格式，因其易于人阅读和编写，同时也易于机器解析和生成，因此在现代Web开发中广泛应用。MySQL从5.7版本开始支持JSON数据类型，这使得存储和查询非结构化数据变得更加便捷。在本书中，作者Dave Stokes，一个有着丰富经验的MySQL社区经理，将引导读者逐步学习如何利用MySQL的新特性处理JSON数据。他从基础开始，包括如何插入、查询和更新JSON文档，再到更高级的主题，如使用JSON函数进行复杂的数据操作，如路径导航、查找、修改和验证。此外，书中还会介绍如何在MySQL中使用JSON字段进行索引，以提高查询性能。技术编辑Frédéric Descamps，作为Percona（一家专注于MySQL的专业公司）的MySQL社区经理，也为本书提供了专业的技术支持。他的专业背景和对开源项目的热情，确保了本书内容的准确性和实用性。读者可以期待从本书中学到以下知识点： 1. **JSON基础**：了解JSON的数据结构，包括对象、数组、字符串、数字、布尔值和null。 2. **MySQL中的JSON数据类型**：学习如何在MySQL表中创建和使用JSON列。 3. **JSON函数**：探索MySQL提供的JSON函数，如`JSON_EXTRACT`用于提取数据，`JSON_INSERT`用于插入数据，`JSON_MODIFY`用于更新数据，以及`JSON_VALID`用于验证JSON文档的语法。 4. **查询JSON数据**：理解如何使用`->`和`->>`操作符来查询JSON字段，并使用`LIKE`、`REGEXP`等操作符进行模糊匹配。 5. **JSON索引**：学习如何创建和使用JSON字段的索引来优化查询性能。 6. **案例研究**：通过实际的例子来展示如何在真实世界的应用场景中使用MySQL和JSON。本书适合已经有一定MySQL基础，想要扩展到非结构化数据领域的开发者，或者是正在寻找一种更灵活的方式来存储和查询数据的数据库管理员。通过本书的学习，读者将能够有效地将JSON集成到他们的MySQL应用程序中，提高数据处理的灵活性和效率。

Introduction 3

Oracle_Flash / MySQL and JSON / Stokes / 013544-6 / Chapter 1

programmers use objects and/or arrays on a regular basis. The simple design

of JSON enables it to be independent of the computer language used to

generate or read the data.

So what does JSON look like? Here’s a simple example:

Example 1-1 Example of a JSON document

{

"name" : "Bond",

"first": "James",

"ID" : "007"

}

The data is enclosed within curly braces, which tells us it is a JSON

object, rather than an array, which would have the data within square

brackets. Inside this object are three key/value pairs: name/Bond, first/

James, and ID/007. Although all of the data could have been placed on one

line and would still be a valid JSON document, it is formatted as multiple

lines for ease of reading. For now, you can consider all the keys and their

values as strings.

UTF8MB4 Character Set

The JSON specifications mandate the use of the UTF8MB4 character set.

This character set allows the encoding of many languages, graphics, and

emoji. Note that UTF8MB4 is a 4-bit character set, which means this data

will take up four times as much space as data in a simpler character set

such as Latin-1. In some cases, this inefficiency may preclude the use of

the JSON data type, despite its rich ability to store a wide variety of data.

MySQL

This is not a book on administrating, programming, or using MySQL. To use

the information in this book, however, you will need access to a server run-

ning MySQL 5.7.5 or later, on a local system or system available over a net-

work. The Community Edition of the MySQL server is free and available for

Microsoft Windows, Linux, and Mac OS; or it’s available as source code.

There is a paid Enterprise Edition for customers with support contracts, and

the examples included herein will also work with this edition.

01-ch01.indd 3 13/04/18 4:16 PM

Introduction 5

Oracle_Flash / MySQL and JSON / Stokes / 013544-6 / Chapter 1

NOTE In some cases, the schema may not be created already, and it will report

an error. This is easy to fix, and you can re-create the schema with

mysqlsh -u root --sql --recreate-schema --schema=world_x < world_x.sql

How to Use This Book

This book was designed for readers to enter the examples on their own

installations of MySQL. Some people can learn very efficiently by just read-

ing, but many more gain additional insight by typing the examples into their

own MySQL instance. The simple examples that follow can easily be deleted

later when no longer needed.

The official MySQL software documentation is the definitive reference on

the various features of MySQL. However, the examples in the documentation

are often hard to grasp for novices at the start of the learning curve or for the

experienced but not in a certain facet. So use this book to backfill areas where

the manual is nebulous, confusing, or just not at your level.

Some points, such as array numbering starting at zero and document

pathing, are restated over and over again and may seem tiresome and

pedantic for those reading from the first page through to the last. But many

readers will use this book by referring only to the part of a section that

concerns them at the moment. Those folks may be oblivious to warnings

presented a page or more earlier, and being dogmatic on these points will

save those people grief.

One of the problems in learning computer technologies is learning to

understand mistakes. This includes learning to understand error messages

and warnings. If you make a mistake in entering one of the examples,

examine any messages for clues and then compare what has been entered

with what is in this text. It’s quite common to miss a single or double quote

and transpose keywords when entering SQL, but the server will not simply

tell you that you fat-fingered a code entry. So you must learn to comprehend

the error messages to find out where you have goofed. Do not be afraid to make

mistakes! Mistakes are part of learning, and learning to fix mistakes is part of

the process. Many martial arts experts stress that the difference between a

novice and a master is that a master knows when a mistake is starting and

01-ch01.indd 5 13/04/18 4:16 PM

剩余128页未读，继续阅读

xd大勇

粉丝: 33
资源: 92

MySQL与JSON实战指南：编程入门

MySQL and JSON A Practical Programming Guide 2018

Practical Guide for Oracle SQL,T-SQL and MySQL 无水印原版pdf

MySQL.and.JSON

[Practical Exercise] Data Storage and Analysis: Storing Scraped Data into MySQL and Performing Data ...

Python and MySQL: Best Practices for Building RESTful APIs to Store Data

The Scientific Approach to Data Exchange Between Python and MySQL

Python for Reading and Writing Large Datasets: Best Practices for MySQL Performance Optimization

[In-depth Analysis of ORM]: Mastering the Art of Interaction Between SQLAlchemy and MySQL

Data Migration Tips: How to Efficiently Store Data in MySQL Using Python

Pytorch版代码幻灯片.zip

最新资源