Search Results
https://dev.mysql.com/doc/refman/8.4/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
row *************************** Table: auto_0 Create Table: CREATE TABLE `auto_0` ( `c1` varchar(50) DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.00 sec) mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/date-calculations.html
You determine which animals these are by checking whether the death value is NULL. MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
Example 17.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate count of pages that contain system data by excluding pages where the TABLE_NAME value is either NULL or includes a slash / or period . The InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-plugin-information.html
Any that have a PLUGIN_LIBRARY value of NULL are built in and cannot be unloaded. row *************************** PLUGIN_NAME: binlog PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 80100.0 PLUGIN_LIBRARY: ... There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
The value is NULL if the row has not been changed since the sys schema was installed. (For example, the variable corresponding to the diagnostics.include_raw option is @sys.diagnostics.include_raw.) If the user-defined variable exists in the current ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-row-nonblocking.html
The two functions differ as follows: mysql_fetch_row() returns a MYSQL_ROW value containing the next row, or NULL. The meaning of a NULL return depends on which function was called preceding mysql_fetch_row(): When used after mysql_store_result() or ... enum net_async_status mysql_fetch_row_nonblocking(MYSQL_RES *result, MYSQL_ROW *row) Description Note mysql_fetch_row_nonblocking() is an asynchronous ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-model-active.html
If user is set to current or NULL, the following information displays. Use the ML_MODEL_ACTIVE routine to check which models are loaded and active for which users. All active users and models share the amount of memory defined by the shape, and it ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-deploy.html
Follow this procedure to deploy a sandbox or production InnoDB ClusterSet deployment. A sandbox deployment is where all the MySQL server instances and other software run on a single machine. For a production deployment, the server instances and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-using-pager.html
You can configure MySQL Shell to use an external pager tool such as less or more. Once a pager is configured, it is used by MySQL Shell to display the text from the online help or the results of SQL operations. Use the following configuration ...