Search Results
https://dev.mysql.com/doc/internals/en/creating-index-keys.html
As part of every table-write operation (INSERT, UPDATE, DELETE), the storage engine is required to update its internal index information. The method used to update indexes will vary from storage engine to storage engine, depending on the method ...
https://dev.mysql.com/doc/x-devapi-userguide/en/sql-crud-functions.html
The following SQL CRUD functions are available in X DevAPI. Table.insert() The Table.insert() method works like an INSERT statement in SQL. It is used to store data in a relational table in the database. The example assumes that the test schema ...
https://dev.mysql.com/doc/internals/en/select-structure.html
There are two structures that describe selects: st_select_lex (SELECT_LEX) for representing SELECT itself st_select_lex_unit (SELECT_LEX_UNIT) for grouping several selects in a bunch The latter item represents UNION operation (the absence of UNION ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/internals/en/select-subquery.html
In expressions, subqueries (that is, subselects) are represented by Item inherited from Item_subselect. To hide difference in performing single SELECTs and UNIONs, Item_subselect uses two different engines, which provide uniform interface for ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview.html
The Migration Wizard performs the following steps when migrating a database to MySQL: Connects to the source RDBMS and retrieves a list of available databases/schemas. Reverse engineers selected database/schemas into a internal representation ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-prepare.html
Before proceeding, you will need the following: Follow the installation guide for installing iODBC on your system. Access to a running PostgreSQL instance with privileges to the database you want to migrate, otherwise known as the "source ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-general-information.html
ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. ODBC is a standardized API that enables connections to SQL database servers. It was developed according to the specifications ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-general-information.html
ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. ODBC is a standardized API that enables connections to SQL database servers. It was developed according to the specifications ...
https://dev.mysql.com/doc/internals/en/implementing-the-info-method.html
The optimizer requests an update of table information by calling the [custom-engine.html#custom-engine-api-reference-info handler::info()] method. The info() method does not have a return value, instead it is expected that the storage engine will ...