Linked e-resources
Details
Table of Contents
Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Introducing MySQL 8-A New Beginning; Old Features New Again; JSON Data Type; MySQL Shell; X Plugin, X Protocol, and X DevAPI; InnoDB Improvements; New Features; Data Dictionary; Account Management; Removed Options, Variables, and Features; Paradigm Shifting Features; Group Replication; InnoDB Cluster; Summary; Chapter 2: Getting Started with MySQL; Getting to Know MySQL; How Do I Connect to MySQL?; How to Get and Install MySQL; Configuring and Managing Access to MySQL
Configuration FilesCreating Users and Granting Access; Configuring the Document Store; A MySQL Primer; Creating Databases and Tables; Searching for Data; Creating Data; Updating Data; Deleting Data; Using Indexes; Views; Triggers; Simple Joins; Stored Routines; Summary; Chapter 3: JSON Documents; Concepts and Technologies: Jargon Explained; Origins: Key, Value Mechanisms; JSON; Application Programming Interface; NoSQL Interface; Document Store; Introducing JSON Documents; JSON Format Rules; Using JSON in MySQL; Path Expressions; JSON Functions; Creating JSON Data; Modifying JSON Data
Searching JSON DataUtility Functions; Combining SQL and JSON - Indexing JSON Data; Summary; Chapter 4: The MySQL Shell; Getting Started; Features; Shell Commands; Options; Sessions and Modes; Session Objects; Modes Supported; Connections; Using a URI; Using Individual Options; Using Connections in Scripts; Using SSL Connections; Set Up and Install; Install the MySQL Shell; Setup the X Plugin; Enable the X Plugin Using the MySQL Shell; Enable the X Plugin Using the MySQL Client; Tutorial: MySQL Shell by Example; Installing the Sample Database; SQL; JavaScript; Python; Summary
Chapter 5: X Developer APIOverview; Clients; Target Language Conformity; MySQL X Module; Classes and Methods; Session Class; Schema Methods; Transaction Methods; Connection Methods; Miscellaneous Methods; CRUD Operations; Schema Class; Collection Class; Table Class; Example Data Used in this Chapter; Working with Data Sets; Document Identifiers; Auto Increment; Accessing Data in Data Sets; Accessing Metadata in Results; Column Metadata; Expressions; Expression Strings; Boolean Expression Strings; Warnings and Errors; Warnings from the Server; Errors from the X DevAPI; Additional Features
Parameter BindingMethod Chaining; CRUD Prepared Statements; Asynchronous Execution; For More Information; Summary; Chapter 6: X Plugin; Overview; Features; Secure Socket Layer (SSL) Connections; Changing the Default Port; Going Deeper-Journey into the Source Code; Options and Variables; How to View Values of Variables; How to Set Values of Variables; System Variables and Startup Options; Status Variables; Monitoring the X Plugin; Communication; Connections; CRUD Operations; Errors and Warnings; Sessions; SSL; Statements; Worker Threads; Summary; Chapter 7: X Protocol; Overview
Configuration FilesCreating Users and Granting Access; Configuring the Document Store; A MySQL Primer; Creating Databases and Tables; Searching for Data; Creating Data; Updating Data; Deleting Data; Using Indexes; Views; Triggers; Simple Joins; Stored Routines; Summary; Chapter 3: JSON Documents; Concepts and Technologies: Jargon Explained; Origins: Key, Value Mechanisms; JSON; Application Programming Interface; NoSQL Interface; Document Store; Introducing JSON Documents; JSON Format Rules; Using JSON in MySQL; Path Expressions; JSON Functions; Creating JSON Data; Modifying JSON Data
Searching JSON DataUtility Functions; Combining SQL and JSON - Indexing JSON Data; Summary; Chapter 4: The MySQL Shell; Getting Started; Features; Shell Commands; Options; Sessions and Modes; Session Objects; Modes Supported; Connections; Using a URI; Using Individual Options; Using Connections in Scripts; Using SSL Connections; Set Up and Install; Install the MySQL Shell; Setup the X Plugin; Enable the X Plugin Using the MySQL Shell; Enable the X Plugin Using the MySQL Client; Tutorial: MySQL Shell by Example; Installing the Sample Database; SQL; JavaScript; Python; Summary
Chapter 5: X Developer APIOverview; Clients; Target Language Conformity; MySQL X Module; Classes and Methods; Session Class; Schema Methods; Transaction Methods; Connection Methods; Miscellaneous Methods; CRUD Operations; Schema Class; Collection Class; Table Class; Example Data Used in this Chapter; Working with Data Sets; Document Identifiers; Auto Increment; Accessing Data in Data Sets; Accessing Metadata in Results; Column Metadata; Expressions; Expression Strings; Boolean Expression Strings; Warnings and Errors; Warnings from the Server; Errors from the X DevAPI; Additional Features
Parameter BindingMethod Chaining; CRUD Prepared Statements; Asynchronous Execution; For More Information; Summary; Chapter 6: X Plugin; Overview; Features; Secure Socket Layer (SSL) Connections; Changing the Default Port; Going Deeper-Journey into the Source Code; Options and Variables; How to View Values of Variables; How to Set Values of Variables; System Variables and Startup Options; Status Variables; Monitoring the X Plugin; Communication; Connections; CRUD Operations; Errors and Warnings; Sessions; SSL; Statements; Worker Threads; Summary; Chapter 7: X Protocol; Overview