Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
This statement may be a compound statement made up of several statements separated by semicolon (;) characters. You should avoid the use of the backslash (\) character because that is the escape character for MySQL. Each stored program contains a ...
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/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
By default, validate_password.changed_characters_percentage permits all of the characters from the current password to be reused in the new password. If set to 100 percent, all of the characters from the current password are rejected, regardless of ... This section describes the system and status variables that validate_password provides to enable its operation to be configured and ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
The \ path name separator character Path name components in Windows are separated by the \ character, which is also the escape character in MySQL. If the pipe includes the character ^Z / CHAR(24), Windows thinks that it has encountered end-of-file ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36006295) Character Set Support When the character_set_server system variable was set using SET PERSIST or SET GLOBAL, it did not take effect for new client sessions or for a client establishing a connection to the server after the server was ...(Bug #36301441) Audit log filtering by type, using error as the type, did not work ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...We solve this by introducing a separate MEM_ROOT object for storing the bind parameters array, which object can be cleared (deallocating the memory) on each call to mysql_stmt_bind_param() or ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-plugin-interface.html
For example, a client that supports the use of authentication plugins normally causes a plugin to be loaded by calling mysql_options() to set the MYSQL_DEFAULT_AUTH and MYSQL_PLUGIN_DIR options: char *plugin_dir = "path_to_plugin_dir"; char ... This ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-library-init.html
int mysql_library_init(int argc, char **argv, char **groups) Description Call this function to initialize the MySQL client library before you call any other MySQL function. Note To avoid memory leaks after the application is done using the library ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-list-fields.html
MYSQL_RES * mysql_list_fields(MYSQL *mysql, const char *table, const char *wild) Description Note mysql_list_fields() is deprecated and is subject to removal in a future version of MySQL. wild may contain the wildcard characters % or _, or may be a ...Instead, use mysql_real_query() or mysql_query() to execute a SHOW COLUMNS ...