Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-query-iter.html
The following example shows how to iterate through the results after sending multiple statements: statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in cnx.cmd_query_iter(statement): if 'columns' in result: columns = ... Syntax: ...Use cmd_query_iter() when sending multiple statements, and separate the statements with ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-query-iter.html
The following example shows how to iterate through the results after sending multiple statements: statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in cnx.cmd_query_iter(statement): if 'columns' in result: columns = ... Syntax: ...Use cmd_query_iter() when sending multiple statements, and separate the statements with ...
https://dev.mysql.com/doc/internals/en/event-meanings.html
INTVAR_EVENT Written every time a statement uses an AUTO_INCREMENT column or the LAST_INSERT_ID() function; precedes other events for the statement. An INTVAR_EVENT is written with a "subtype" in the event data part: INSERT_ID_EVENT indicates the ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords.html
This section contains information on the keywords and reserved words within the server when creating and submitting queries to the system. For more information on reserved words and their impact on your queries, see Keywords and Reserved Words, in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-group-by-modifiers.html
The ROLLUP modifier generates aggregated results that follow the hierarchy for the selected columns. The CUBE modifier generates aggregated results for all possible combinations of the selected columns. In the MySQL HeatWave secondary engine, the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
INTO OUTFILE {URL | URI} 'uri' [FORMAT csv] [CHARACTER SET 'charset_name'] [HEADER {ON | OFF}] [{FIELDS | COLUMNS} [NULL AS 'null_char'] [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ... {COLUMNS | FIELDS} TERMINATED ... This topic shows the different ways to export query results as a CSV file with SQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-temp-table-info.html
The NAME column displays the system-generated name for the temporary table, which is prefixed with “#sql”. The number of columns (N_COLS) is 4 rather than 1 because InnoDB always creates three hidden table columns (DB_ROW_ID, DB_TRX_ID, and ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
With a nonconstant initializer argument (such as a column name), the seed is initialized with the value for each invocation of RAND(). One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
The MRR optimization is not supported with secondary indexes created on virtual generated columns. When MRR is used, the Extra column in EXPLAIN output shows Using MRR. Reading rows using a range scan on a secondary index can result in many random ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_default_column_format: Sets default row format and column format (FIXED or DYNAMIC) used for ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...