PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html
The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for example with monetary data. In MySQL, NUMERIC is implemented as DECIMAL, so the following remarks about ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
For information about the <ctype><map> array format, see Section 12.13.1, “Character Definition Arrays”. For general information about adding collations, see Section 12.14, “Adding a Collation to a Character Set”. You can exert more control ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
Consequently, the thread is changing the temporary table from in-memory to disk-based format to save memory. State includes information such as number of rows, the AUTO_INCREMENT counter, and key distributions. The following list describes thread ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 7.3, “The mysql System Schema”. For ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Be careful when using MD5() to produce table names because it can produce names in illegal or ambiguous formats such as those just described. See Section 11.4, “User-Defined Variables”, for more information and examples of workarounds. Certain ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. DEFINER The account named in the DEFINER clause (often the user who created the event), in ...The EVENTS table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...The ...