PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-list.html
This is done by using PARTITION BY LIST(expr) where expr is a column value or an expression based on a column value and returning an integer value, and then defining each partition by means of a VALUES IN (value_list), where value_list is a ... List ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-decimal-characteristics.html
The storage requirements for the integer and fractional parts of each value are determined separately. Leftover Digits Number of Bytes 0 0 1–2 1 3–4 2 5–6 3 7–9 4 For example, a DECIMAL(18,9) column has nine digits on either side of the ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-examples.html
Rounding for exact-value columns (DECIMAL and integer) and exact-valued numbers uses the “round half away from zero” rule. A value with a fractional part exactly half way between two integers is rounded to the nearest even integer: mysql> SELECT ... This section provides some examples that show precision math query results in ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
First we create a table t2 containing three integer columns, like this: mysql> CREATE TABLE t2 (c1 INT, c2 INT, c3 INT); Query OK, 0 rows affected (0.04 sec) Now we can create a trigger on this table. This section contains examples illustrating a ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-logs-configuration.html
telemetry.otel_exporter_otlp_logs_timeout System Variable telemetry.otel_exporter_otlp_logs_timeout Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 10000 Unit milliseconds Time in milliseconds the OTLP exporter waits for ...For information on the configured loggers, see Section 29.12.21.1, “The setup_loggers ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-configuration.html
telemetry.metrics_reader_frequency_1 System Variable telemetry.metrics_reader_frequency_1 Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 10 Unit seconds Mandatory. For example: SELECT * from ... This section lists the ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-plugin-variables.html
connection_control_max_connection_delay Command-Line Format --connection-control-max-connection-delay=# Deprecated Yes System Variable connection_control_max_connection_delay Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default ...
https://dev.mysql.com/doc/refman/9.7/en/converting-tables-to-innodb.html
For the ranges of the different integer types, see Section 13.1.2, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT”. If you have MyISAM tables that you want to convert to InnoDB for better reliability and ...
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
For example, if a function specifies an ENUM or SET value in the RETURNS clause, but the RETURN statement returns an integer, the value returned from the function is the string for the corresponding ENUM member of set of SET members. By default, a ...