Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/understanding-automatic-document-ids.html
When using manual document IDs, you must ensure that they do not clash with any IDs that might ever be generated automatically by the server (see Document ID Generation for details), in order to avoid any errors due to primary key duplication. This ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-document-ids.html
This section describes what a document ID is and how to work with it. Every document has a unique identifier called the document ID, which can be thought of as the equivalent of a table's primary key. The document ID value is usually automatically ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. This enables you to control row locking to ensure safe, transactional document updates on collections and to ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. An SqlResult combines a result set produced by, for example, ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configuration-file.html
Upon the completion of the deployment described in this guide, the MySQL configuration file (/etc/my.cnf) contains these configuration settings: [mysqld] datadir=/usr/local/mysql/data socket=/tmp/mysql.sock port=3306 ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-install.html
This section covers installation prerequisites, creating the mysql user and group, and unpacking the distribution. Installation Prerequisites Creating the mysql User and Group Unpacking the Distribution Installation Prerequisites The installation ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html
The validate_password component serves to test user-specified passwords and improve security. The component exposes a set of system variables that enable you to define a password policy. The component implements two capabilities: In statements that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-remove.html
remove() returns an error if no search condition string is provided, or if an empty string is provided. The Collection.remove() function is for removing documents in a collection, similar to the DELETE statement for an SQL database. It takes a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/devapi-users-statement-execution.html
This section explains statement execution, with information on how to handle transactions and errors.