Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
tls-versions Define the allowed TLS protocol versions TLSv1.2,TLSv1.3 (set by libmysqlclient) Accepts TLSv1.2 and/or TLSv1.3; while other values generate an error. NO_SCHEMA Disables support for ODBC schemas 64 Ignore use of database schema name in ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
tls-versions Define the allowed TLS protocol versions TLSv1.2,TLSv1.3 (set by libmysqlclient) Accepts TLSv1.2 and/or TLSv1.3; while other values generate an error. NO_SCHEMA Disables support for ODBC schemas 64 Ignore use of database schema name in ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any BLOB columns. For character and string columns, follow these guidelines: Use ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #34574604) InnoDB: ON DELETE CASCADE with generated columns containing secondary indexes sometimes failed, due to virtual column templates not being initialized before deletion. (Bug #37271715) InnoDB: It was possible for an ALTER TABLE ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-forecasting-model.html
The model uses this column as an index for the forecast variable. The following data types for this column are supported: DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing index. One of these columns must also be specified as the ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
A derived table is an expression that generates a table within the scope of a query FROM clause. The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... For ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
Column and line terminators can be specified to produce a specific output format. SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; INTO var_list can also be used with a TABLE statement, subject to these restrictions: The number of variables must ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Keys and indexes on NDB Cluster tables are subject to the following limitations: Column width. Attempting to create an index on an NDB table column whose width is greater than 3072 bytes is rejected with ER_TOO_LONG_KEY: Specified key was too long; ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30.html
Advisor MySQL HeatWave AutoML Functionality Added or Changed Advisor MySQL HeatWave Advisor Auto Encoding, which recommends string column encodings, now provides encoding recommendations that optimize query performance. Previously, string column ...