Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-format-conversion-functions.html
If the options argument is NULL, the return value is NULL. MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates.
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-load-dump.html
Before attempting an import using the ignoreVersion option, use MySQL Shell's upgrade checker utility checkForServerUpgrade() to check the schemas on the source MySQL instance. MySQL Shell's dump loading utility util.loadDump() supports the import ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
You can indicate that a function returns NULL or that an error occurred. (To use the default for a member, leave it unchanged.) bool maybe_null xxx_init() should set maybe_null to 1 if xxx() can return NULL. The default value is 1 if any of the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Empty columns are automatically filled with default column values or NULL. Empty columns are automatically filled with default column values or NULL. Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. Retrained attributes are NULL (or NOT NULL) and, ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/internals/en/event-header-fields.html
The value of this constant is 13 in MySQL 3.23 (v1 format), and 19 in MySQL 4.0 and up (v3 format and up). The first 19 bytes for v4 are the same as those for v3. Because the event header in a newer binary log format starts with the header of the ...
https://dev.mysql.com/doc/internals/en/x-protocol-expect-expectations.html
Assume the PrepareFind fails: don't execute the Execute don't try to close the stmt Mysqlx.Expect::Open([+no_error]) Mysqlx.Crud::PrepareFind(stmt_id=1, ...) // may fail Mysqlx.PreparedStmt::Execute(stmt_id=1, ...) // expectation(no_error) failed ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-simple.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using local functions. It then reads the columns back and extracts the data from them using local functions. See Section 2.5.15, “Common Files ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
If you set the options to NULL, the data loads in normal mode by default. After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic ...