brightsetr.blogg.se - Mysql shell

#Mysql shell how to#
#Mysql shell upgrade#

Represent BSON data types, convert them to an identical orĬompatible MySQL representation, and import the data value using Utility can process documents that use JSON extensions to Represented using extensions to the JSON format. The data types used inīSON documents are not all natively supported by JSON, but can be The JSON import utility can process BSON (binary JSON) data types Supplied import file (without the file extension), and the default The default collection name or table name is the name of the The default collection is createdīy calling the createCollection() functionįrom a schema object. Is automatically created by the utility, using a defaultĬollection or table structure. Table or collection does not exist in the specified database, it You can import the JSON documents to an existing table orĬollection or to a new one created for the import. Into the target database, removing the need to use multiple That the supplied JSON documents are well-formed and inserts them

Util.importJSON() enables you to import JSONĭocuments from a file (or FIFO special file) or standard input toĪ MySQL Server collection or relational table. All rights reserved.11.2.1 Running the Utility 11.2.2 Importing JSON Documents With the Mysqlsh Command Interface 11.2.3 Importing JSON Documents With the -import Command 11.2.4 Conversions for Representations of BSON Data Types The Group Replication documentation provides detailed documentation on the replication group which InnoDB Cluster utilizes.Ģ014, 2023, Oracle and/or its affiliates.

#Mysql shell how to#

The InnoDB Cluster user guide explains how to use MySQL Shell and AdminAPI to set up and administer a highly available InnoDB Cluster.The X DevAPI user guide provides details about and usage examples of the X DevAPI.The Using MySQL as a Document Store documentation explains how to use X DevAPI to achieve a NoSQL-like MySQL database.For additional details look at the connect function in the shell object.įor more information on the functionality these APIs provide see the following documentation: 1 The session global object might be either a ClassicSession or a Session object depending on whether the global session was established using classic MySQL protocol or X protocol respectively. The sys global object gives access to system specific parameters.The os global object gives access to functions which allow to interact with the operating system.

#Mysql shell upgrade#

The util global object that groups miscellaneous tools like upgrade checker and JSON import.

The db global object is available when the global session is established through the X protocol using a default database.

The session 1 global object is available when a global session is established.

The shell global object gives access to general purpose functions and properties.

The dba global object enables you to administer InnoDB clusters using the AdminAPI.

The mysql module contains a lightweight development API to interact with MySQL Servers using a classic session.

The mysqlx module contains a complete development API to interact with MySQL Servers using a session through the X Protocol.

The functionality of the APIs is exposed through modules and global objects which are automatically available when the MySQL Shell starts.

AdminAPI - API for setting up and managing InnoDB Clusters, InnoDB ReplicaSets, and InnoDB ClusterSets.

ShellAPI - Shell API and backward compatibility API for MySQL Servers not supporting the X DevAPI.

X DevAPI - NoSQL Database API for MySQL and the MySQL Document Store.

This document covers the JavaScript APIs available in the MySQL Shell: