Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. This topic shows the different ways to export query results as an ND-JSON file. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ("uri": ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-variables.html
This section describes the system and status variables that the CONNECTION_CONTROL plugin provides to enable its operation to be configured and monitored. If an account has reached the point where connection responses are delayed, a delay also ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_bind_base_dn Command-Line Format --authentication-ldap-sasl-bind-base-dn=value System Variable authentication_ldap_sasl_bind_base_dn Scope Global Dynamic Yes SET_VAR Hint Applies No Type String Default Value NULL For SASL ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
CertificateFile , Certificate File Default: null This option specifies the path to a certificate file in PKCS #12 format (.pfx). CertificatePassword , Certificate Password Default: null Specifies a password that is used in conjunction with a ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
CertificateFile , Certificate File Default: null This option specifies the path to a certificate file in PKCS #12 format (.pfx). CertificatePassword , Certificate Password Default: null Specifies a password that is used in conjunction with a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--output-type=name Command-Line Format --output-type=name Type Enumeration Default Value ndb Valid Values null Set the output type. ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. ndb_import requires a connection to an NDB management server (ndb_mgmd) to function; it does not require a connection to a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
The result type depends on whether the function argument values are evaluated as binary strings or numbers: Binary-string evaluation occurs when the argument values have a binary string type, and the argument is not a hexadecimal literal, bit ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
It provides useful information for the query optimizer, because the column is known to be not null and with unique values. A column can be subject to a unique constraint, a NOT NULL constraint, or both. See Also cardinality, foreign key, index, NOT ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...