Search Results
https://dev.mysql.com/doc/internals/en/decoding-specification.html
Alignment: x bits alignment to the next byte border Code Trees. For every record: 1-5 bytes length of the compressed record in bytes 1.
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Client informs about the user account it wants to log into in the Handshake Response Packet. Only then server can look-up the mysql.user ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-myisam.html
We will begin by mentioning that myisam is one of what we call the MySQL storage engine directories. But the files in those directories are mostly analogues of what's in the myisam directory, and the myisam directory is sort of a 'template'. On the ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-status-variables.html
The Administration - Status and System Variables secondary tab lists the full set of server variables for the active MySQL connection. You may also copy all or selected variables to your clipboard. You can open this secondary tab from either the ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-php-pdo.html
MySQL Workbench includes a plugin that generates PHP code with the mysqli extension. This tutorial shows how to generate code with the PDO_MySQL extension for PHP. You might choose a different extension or a different language altogether, so adjust ...
https://dev.mysql.com/doc/refman/8.4/en/nested-join-optimization.html
The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a ...
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/mysql-secure-deployment-guide/8.0/en/secure-deployment-roles-dynamic-privileges.html
Privilege management is an important aspect of managing the security of a MySQL installation. Following the principle of least privilege, a MySQL account should only be granted privileges required to for its legitimate purposes. To facilitate ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-handling-errors.html
This program demonstrates handling errors and retrying failed transactions using the NDB API. The source code for this example can be found in storage/ndb/ndbapi-examples/ndbapi_retries/ndbapi_retries.cpp in the NDB Cluster source tree. In this ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which ...