Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/expression-strings.html
Defining string expressions is straightforward as these are easy to read and write. The disadvantage is that they need to be parsed before they can be transfered to the MySQL server. All implementations can use the syntax illustrated here, which is ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-using-strings.html
Enclose string values within double quotation marks in the Expression or the Thresholds text boxes. For example, the expression for the “Slave I/O Thread Not Running” advisor is: (%Slave_running% == "ON") && (%Slave_IO_Running% != THRESHOLD) ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
This section describes how to install the connection control plugins, CONNECTION_CONTROL and CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS. For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”.
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | @@SESSION. | @@] system_var_name } SET syntax for ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
The types of the CTE result columns are inferred from the column types of the nonrecursive SELECT part only, and the columns are all nullable. The use of COALESCE() avoids displaying NULL in the sum_price column on days for which no sales data occur ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
The MySQL server maintains system variables that configure its operation. A system variable can have a global value that affects server operation as a whole, a session value that affects the current session, or both. Many system variables are ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
For a JSON column which has been updated such that its binary representation is the same as or larger than before, or if the update was not able to take advantage of a partial update, it returns 0; it returns NULL if the argument is NULL. If ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
The result is placed in the to argument, followed by a terminating null byte. (In the worst case, each character may need to be encoded as using two bytes, and there must be room for the terminating null byte.) When mysql_real_escape_string_quote() ... unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
The result is placed in the to argument, followed by a terminating null byte. (In the worst case, each character may need to be encoded as using two bytes, and there must be room for the terminating null byte.) When mysql_real_escape_string() ...