Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
If a table has a PRIMARY KEY or UNIQUE NOT NULL index that consists of a single column that has an integer type, you can use _rowid to refer to the indexed column in SELECT statements, as described in Unique Indexes. If a table has a PRIMARY KEY or ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
For each server, you should pick a unique positive integer in the range from 1 to 232 − 1, and each ID must be different from every other ID in use by any other source or replica in the replication topology. Both variables have global and session ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE COUNTER NUM_TYPE: INTEGER UNIT: DESCRIPTION: Number of active undo tablespaces, including implicit and explicit tablespaces ... The ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-type-conversions.html
MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html
MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_init_pool_size Command-Line Format --authentication-ldap-sasl-init-pool-size=# System Variable authentication_ldap_sasl_init_pool_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
margin1: A nonnegative integer that specifies the number of characters on the left end of the string to remain unmasked. margin2: A nonnegative integer that specifies the number of characters on the right end of the string to remain unmasked.
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-syntax.html
$.router.port.ro: (integer) matches the port number MySQL Router listens to for incoming, read-only connections. $.router.port.rw: (integer) matches the port number MySQL Router listens to for incoming, read-write connections. The top-level ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. This optional display width may be used by applications to display integer values having a width ...For example, INT(4) specifies an INT with a display width of four ...