Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/expression-strings.html
The disadvantage is that they need to be parsed before they can be transfered to the MySQL server. Defining string expressions is straightforward as these are easy to read and write. All implementations can use the syntax illustrated here, which is ...
https://dev.mysql.com/doc/x-devapi-userguide/en/setting-the-current-schema.html
*/ C# Code // Direct connect with no client-side default schema specified var mySession = MySQLX.GetSession("server=localhost;port=33060;user=user;password=password;"); mySession.SetCurrentSchema("test"); Python Code # Connector/Python from mysqlsh ... A default schema for a session can be specified using the schema attribute in the URI-like connection string or key-value pairs when opening a connection ...
https://dev.mysql.com/doc/x-devapi-userguide/en/value-expression-strings.html
Value expression strings are used to compute a value which can then be assigned to a given field or column. This is necessary for both modify() and update(), as well as computing values in documents at insertion time. An example use of a value ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-auto-increment-values.html
The reason for this is to make it possible to reproduce easily the same operation against some other server. AUTO_INCREMENT columns can be used in MySQL for generating primary key or id values, but are not limited to these uses. This section ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/index.html
It documents procedures for deploying a Linux-generic binary distribution of MySQL Enterprise Edition Server with features for implementing and managing the security of a MySQL installation. The deployment described in this guide is performed on ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-data-masking.html
MySQL Enterprise Data Masking and De-Identification is implemented as a plugin library file that contains these components: A server-side plugin named data_masking. As of MySQL 8.0.13, MySQL Enterprise Edition provides data masking and ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/devapi-users-working-with-relational-tables.html
The X DevAPI SQL CRUD functions allow you to work with relational tables in manners similar to using traditional SQL statements. The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/error-handling.html
When writing scripts for MySQL Shell you can often simply rely on the exception handling done by MySQL Shell. For all other languages either proper exception handling is required to catch errors or the traditional error handling pattern needs to be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/expression-strings.html
The disadvantage is that they need to be parsed before they can be transfered to the MySQL server. Defining string expressions is straightforward as these are easy to read and write. All implementations can use the syntax illustrated here, which is ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...