Search Results
https://dev.mysql.com/doc/internals/en/floating-point-types.html
The MySQL Reference Manual has a discussion of floating-point numbers in Section 11.2 Numeric Types, including details about the storage. Let us now take up the story from where the MySQL Reference Manual leaves off. This document was created when ...The following discussion concentrates on the case where no display width and decimals are ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates.html
This section provides an overview of creating and modifying DBDoc Model Reporting templates, as used by MySQL Workbench. The MySQL Workbench DBDoc Model Reporting system is based on the Google Template System. These text files are processed by the ...This discussion does not attempt to explain the Google Template System in ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
However, only one request is sent from the MySQL Server, and the read of the index table is handled by the data node. When an ordered index is used, it performs a scan in the same manner as the full table scan, except that it scans only those ... An ...
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). It is represented as the number of seconds since 1970 (UTC), like the TIMESTAMP SQL data type. The ID of the mysqld server that originally ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
In MySQL terminology, a "key" is something that you create with CREATE [UNIQUE] INDEX. If MySQL shifts key values up after a DELETE, the end of the block is not overwritten. If all blocks have the same normal block length (1024), then MySQL will ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial Editions. The following submenu items apply to the active model tab, EER diagram tab, or both: ...9.1.1.1.1 The File Menu Use the File menu to open a project, begin a new project, or save a ...
https://dev.mysql.com/doc/internals/en/com-query-response.html
While a TIMESTAMP field may be a MYSQL_TYPE_TIMESTAMP or MYSQL_TYPE_TIMESTAMP2 within the MySQL Server depending on the version, in the protocol it always is MYSQL_TYPE_TIMESTAMP. Image description If it is not a valid Protocol::LengthEncodedInteger ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
This tutorial describes how to use Explain reports to locate and fix problematic (slow) queries. SELECT * FROM orders WHERE YEAR(o_orderdate) = 1992 AND MONTH(o_orderdate) = 4 AND o_clerk LIKE '%0223'; As shown in the figure that follows, the query ...It uses the DBT-3 database and begins with the following simple query ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. MySQL Server 5.6 and higher can ...SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in ...
https://dev.mysql.com/doc/internals/en/guided-tour-chunk.html
Now, having finished with our bird's eye view of the source code from the air, let's take the perspective of the worms on the ground (which is another name for MySQL's developer staff -- turn on laugh track here). if (updated && (error <= 0 || ...