Search Results
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
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/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-import.html
The table must meet the following criteria: There must be only one row in the table with chunk_id = 1. ML_MODEL_IMPORT stores the model_metadata corresponding to chunk_id = 1 in the model catalog, and ignores the model_metadata from other rows. If ... Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
Alternatively, tbl_name may be followed by a parenthesized list of names for the derived table columns: SELECT ... This can occur if the outer query accesses any tables and an inner query invokes a stored function that changes one or more rows of a ...For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
The Performance Schema also counts internal threads and threads for user sessions that failed to authenticate, using rows with USER and HOST column values of NULL. The Performance Schema tracks the connections as follows: The accounts table has four ... When a client connects to the MySQL server, it does so under a particular user name and from a particular ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G ...When the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
If the local value is set, the new value affects AUTO_INCREMENT columns for all tables into which new rows are inserted by the current user for the duration of the session, unless the values are changed during that session. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
row *************************** Level: Warning Code: 3162 Message: Authorization ID jerry does not exist. | +---------+------+--------------------------------------------+ 2 rows in set (0.00 sec) Roles named in the mandatory_roles system variable ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/internals/en/binlog-formats.html
In row format: rows that changed are written to the binlog in a binary format. Each row may consist of a Before Image (BI) and/or an After Image (AI). The BI identifies the row to modify and the AI describes the row after the change. There are three ... Status of this subsection: Complete but not reviewed 2009-10-21 The binlog is organized as a linear sequence of ...