Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
This topic contains the following sections: Before You Begin Selective Load Overview Use the ALTER TABLE Statement Use Auto Parallel Load What's Next Before You Begin Load structured data using Lakehouse Auto Parallel Load or manually. You can edit ... Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
As of MySQL 9.5.0, queries that call a stored function are supported with the following limitations: The query runs with forced secondary engine only: SET use_secondary_engine=forced; The function definition must not contain IF or ELSE statements.
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
The routine also runs the generated SQL statement and displays the result set. The routine automatically detects these errors, and retries the SQL generation until a syntactically valid SQL statement is generated, with a maximum of 3 generation ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
It demonstrates that you can use mysql as a simple calculator: mysql> SELECT SIN(PI()/4), (4+1)*5; +------------------+---------+ | SIN(PI()/4) | (4+1)*5 | +------------------+---------+ | 0.70710678118655 | 25 | +------------------+---------+ 1 row ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
To achieve this, you need only run the SQL statement SET @@SESSION.group_replication_consistency= ‘BEFORE’ prior to executing the command. Some queries that do not modify data are allowed, such as the following: SHOW statements: These are ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
However, in most cases, the change takes effect only after you stop and restart Group Replication on the group member using a STOP GROUP_REPLICATION statement followed by a START GROUP_REPLICATION statement. System variables for Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. These are sufficient for the statement to read the file ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... # at 400 #080828 15:03:08 server id 1 end_log_pos 442 Delete_rows: table id 17 flags: STMT_END_F ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. The SELECT statement in the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”). When binlog_format=MIXED is set, the statement is logged in row-based format. When ...This ...