Search Results
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
A string value to be compared with a column must use the same collation as the column. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user account. For example: ALTER USER user ...The ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced ...
https://dev.mysql.com/doc/refman/8.4/en/year.html
YEAR accepts input values in a variety of formats: As 4-digit strings in the range '1901' to '2155'. As 1- or 2-digit strings in the range '0' to '99'. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. As the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encryption.html
The encryption is performed with Advanced Encryption Standard (AES) block cipher in CBC mode, with a key string of 64 hexadecimal digits supplied by the user. In order to enhance security for backed up data, MySQL Enterprise Backup provides ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options4.html
The first and second strings indicate the key and value, respectively. See also the descriptions for the MYSQL_OPT_CONNECT_ATTR_RESET and MYSQL_OPT_CONNECT_ATTR_DELETE options in the description of the mysql_options() function. The second argument ... int mysql_options4(MYSQL *mysql, enum mysql_option option, const void *arg1, const void *arg2) Description mysql_options4() is similar to mysql_options() but has an extra fourth argument so that two values can be passed for the option specified in the second ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-example.html
Replace the generic connection string with one that is appropriate for your MySQL server configuration. The Code First approach enables you to define an entity model in code, create a database from the model, and then add data to the database.
https://dev.mysql.com/doc/connectors/en/connector-net-interceptors.html
With MySQL Connector/NET, the interceptors are enabled and disabled by updating the connection string to refer to different sets of interceptor classes that you instantiate. The BaseCommandInterceptor class has these methods that you can override: ... An interceptor is a software design pattern that provides a transparent way to extend or modify some aspect of a program, similar to a user ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-example.html
Replace the generic connection string with one that is appropriate for your MySQL server configuration. The Code First approach enables you to define an entity model in code, create a database from the model, and then add data to the database.
https://dev.mysql.com/doc/connector-net/en/connector-net-interceptors.html
With MySQL Connector/NET, the interceptors are enabled and disabled by updating the connection string to refer to different sets of interceptor classes that you instantiate. The BaseCommandInterceptor class has these methods that you can override: ... An interceptor is a software design pattern that provides a transparent way to extend or modify some aspect of a program, similar to a user ...