Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
Loadable Function Calling Sequences for Simple Functions This section describes the different interface functions that you must define to create a simple loadable function. Loadable Function Calling Sequences for Aggregate Functions This section ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-installation-source-cpp.html
Only out-of-source-builds are supported, so create a directory to use for the build and change location into it. (However, it may be that your version of CMake supports more generators than can actually be used to build Connector/C++.) If the Boost ... To install Connector/C++ from source, verify that your system satisfies the requirements outlined in Section 2.4.1, “Source Installation System ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--connections=# Command-Line Format --connections=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 Number of cluster connections to create. --resume Command-Line Format --resume If a job is aborted (due to a temporary db error ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
In SHOW statement results, user names and host names are quoted using backticks (`). SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
-DSYSTEMD_PID_DIR=dir_name The name of the directory in which to create the PID file when MySQL is managed by systemd. -DREPRODUCIBLE_BUILD=bool For builds on Linux systems, this option controls whether to take extra care to create a build result ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
An instance of NdbBlob is created using the NdbOperation::getBlobHandle() method during the operation preparation phase. getLength() Gets the length of a blob, in bytes getNdbError() Gets an error (an NdbError object) getNdbOperation() Get a pointer ... This section provides information about the NdbBlob class, which models a handle to a blob column and provides read and write access to blob column ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege for the table to be created. Table files are exported from the export server into the /tmp/export directory and this directory is secure (not ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...