Search Results
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For comparisons of strings to indexed generated columns that compute a value from a JSON function that returns a quoted string, JSON_UNQUOTE() is needed in the column definition to remove the extra quotes from the function value. For example, if the ...For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-error.html
const char * mysql_error(MYSQL *mysql) Description For the connection specified by mysql, mysql_error() returns a null-terminated string containing the error message for the most recently invoked API function that failed. If a function did not ...A ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be installed. If the plugin is installed without the accompanying audit tables and functions needed for rule-based ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-32.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Removed distutils support, which is deprecated in Python 3.10 and removed in Python 3.12. (WL #14861) Adopted type hint enforcement for function and class attributes with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined explicitly as dictionary-encoded columns. Minimizes the amount of data stored for string columns by ...You can ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
Suppose that my_auth_plugin returns a user name of employee to the server, based on the content of 'my_auth_string' and perhaps by consulting some external authentication system. When proxying occurs, the USER() and CURRENT_USER() functions can be ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-29.html
class Fido_Callback { public: Fido_Callback(std::function<void(SQLString)>); /** * Override this message to receive Fido Action Requests */ virtual void FidoActionRequested(sql::SQLString msg); }; Any connection created by the driver can use the ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-19.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Connector/NET supports TLS protocol versions TLSv1, TLSv1.1, TLSv1.2, and TLSv1.3. A new connection-string option, tlsversion, permits the restriction of a connection to a ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-9.html
(WL #10563) The AutoEnlist and IncludeSecurityAsserts connection-string options are not appropriate for use by applications that target .NET Core and now return an error when used. A list of hosts can be given in a connection string or as session ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
To prevent password recovery using rainbow tables, do not use these functions on a plain password; instead, choose some string to be used as a salt, and use hash(hash(password)+salt) values. Instead, use SHA2() or some other one-way hashing function ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...