PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. mysql-py> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with a search condition ...You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-remove.html
mysql-py> db.countryinfo.remove("Code = 'SEA'") Remove the First Document To remove the first document in the countryinfo collection, use the limit() method with a value of 1. mysql-py> db.countryinfo.remove("true").limit(1) Remove the Last Document ... You can use the remove() method to delete some or all documents from a collection in a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html
MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in parallel. A multi-source replica can also be set up as a multi-threaded replica, by setting the system variable replica_parallel_workers ...
https://dev.mysql.com/doc/refman/8.0/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-socket-layer-support-ssl.html
From MySQL 8.0.16, you can change the tls_version system variable at runtime to alter the list of permitted TLS protocol versions for the server. If SSL is used, the means for configuring the secure connection depends on whether the XCom or the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-pausing.html
From MySQL 8.0.22, STOP SLAVE and START SLAVE are deprecated, and STOP REPLICA and START REPLICA are available to use instead. You can stop and start replication on the replica using the STOP REPLICA and START REPLICA statements. The I/O (receiver) ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
For more information on setting up a server and client for encrypted connections, see Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”. To enable encrypted connections on the replica, use the CHANGE REPLICATION SOURCE TO statement ... To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network ...
https://dev.mysql.com/doc/refman/8.0/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. (MySQL Enterprise Edition only) MySQL Enterprise Audit, implemented using a server plugin, ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-troubleshooting.html
File Contexts If a MySQL directory or file has an incorrect SELinux context, access may be denied. This issue can occur if MySQL is configured to read from or write to a non-default directory or file. For example, if you configure MySQL to use a ...