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/information-schema-table-privileges-table.html
The TABLE_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 belongs. TABLE_SCHEMA The name of the schema ...The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. It is strongly recommended that you never change the SQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-extensions-table.html
The TABLES_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table attributes defined for primary and secondary storage engines. The TABLES_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ...As with table partitioned by RANGE, you can use MAXVALUE to represent a value such that any legal value inserted into a given column is always less than this ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server ...The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
For InnoDB tables, use the alternative technique explained in Section 17.6.1.2, “Creating Tables Externally” instead. To instruct a running MySQL server to perform the symlinking, use the DATA DIRECTORY and INDEX DIRECTORY options to CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
(myisampack creates an intermediate file named tbl_name.TMD in the database directory while it compresses the table. When the table is used later, the server reads into memory the information needed to decompress columns. MySQL uses mmap() when ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
This row-by-row calculation is what you get with the EXTENDED clause, with InnoDB and all other storage engines other than MyISAM, and with MyISAM tables not created with the CHECKSUM=1 clause. For MyISAM tables created with the CHECKSUM=1 clause, ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...You can use this statement to verify that the contents are the same before and after a backup, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-extensions-table.html
The TABLE_CONSTRAINTS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table constraint attributes defined for primary and secondary storage engines. The TABLE_CONSTRAINTS_EXTENSIONS table has these columns: ...