Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/internals/en/optimizer-group-by-related-conditions.html
If the table handler has a quick row-count available, then the query SELECT COUNT(*) FROM Table1; gets the count without going through all the rows. This is true for MyISAM tables, but not for InnoDB tables. Note that the query SELECT COUNT(column1) ... These are the main optimizations that take place for GROUP BY and related items (HAVING, COUNT(), MAX(), MIN(), SUM(), AVG(), ...
https://dev.mysql.com/doc/internals/en/source-directory-listing.html
Directory — Short Comment bdb — The Berkeley Database table handler BitKeeper — BitKeeper administration (not part of the source distribution) BUILD — Frequently used build scripts client — Client library cmd-line-utils — Command-line ...
https://dev.mysql.com/doc/internals/en/support-for-update.html
If the table being updated contains timestamp columns, the updating of the timestamp will have to be managed in the update_row() call. Performing an update will depend on row format and storage implementation. Some storage engines will replace data ...
https://dev.mysql.com/doc/mysqld-version-reference/en/build-options.html
The following table details the CMake configuration options available when building MySQL Server from source. An item has a row in the table if it ever existed in any series shown in the table. Introduced: The version or versions in which the item ...
https://dev.mysql.com/doc/mysqld-version-reference/en/built-in-functions.html
The following table shows all built-in functions and operators available in MySQL Server. An item has a row in the table if it ever existed in any series shown in the table. Introduced: The version or versions in which the item was introduced.
https://dev.mysql.com/doc/mysqld-version-reference/en/loadable-functions.html
The following table shows all loadable functions available in MySQL Server. An item has a row in the table if it ever existed in any series shown in the table. Introduced: The version or versions in which the item was introduced. Deprecated: The ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-persistent.html
Table 4.94 column Parameter Description return the name of the column 4.3.2.13.3 extensions Non-standard extensions for this member. Table 4.95 extensions Parameter Description return the non-standard extensions 4.3.2.13.4 nullValue Behavior when ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-insufficient-space.html
The following list enumerates all NDB errors of type IS (Insufficient space).
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationsource-category.html
Table 7.28 Replication Source Configuration Metrics NameDescriptionAuto Increment Increment Controls the interval between successive column values within all AUTO_INCREMENT columns within the MySQL server. Gtid Executed Compression Period Compress ... Lists the Replication Source configuration metrics and provides a brief description of ...