Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-data-encryption.html
After a keyring plugin is installed and configured, encryption can be enabled for: File-per-table tablespaces General tablespaces The mysql system tablespace Redo logs Undo logs For more information, see InnoDB Data-at-Rest Encryption. MySQL Server ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/boolean-expression-strings.html
Boolean expression strings can be used when filtering collections or tables using operations, such as find() and remove(). The following example of a boolean expression string uses find() to search for all documents with a “red” color attribute ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/creating-documents.html
Once a collection has been created, it can store JSON documents. You store documents by passing a JSON data structure to the Collection.add() function. Some languages have direct support for JSON data, others have an equivalent syntax to represent ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/devapi-users-crud-operations.html
This section explains how to use the X DevAPI for Create Read, Update, and Delete (CRUD) operations. X DevAPI extends this domain by adding support for CRUD operations that can be run against collections of documents.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/fetching-all-data-items-at-once.html
The following example assumes that the test schema exists and that the employee table exists in myTable. In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/method-chaining.html
The example assumes that the test schema exists and an employee table exists. // New method chaining used for executing an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var res = ... X DevAPI ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-a-session-object.html
All previous examples used the getSchema() or getDefaultSchema() methods of the Session object, which return a Schema object. Most examples make use of the X DevAPI ability to chain all object constructions, enabling you to get to the Schema object ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-document-ids.html
Every document has a unique identifier called the document ID, which can be thought of as the equivalent of a table's primary key. This section describes what a document ID is and how to work with it. The document ID value is usually automatically ...