PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
This means that the order is undefined for columns that are identical except for their case. You can force a case-sensitive sort for a column by using BINARY like so: ORDER BY BINARY col_name. You may have noticed in the preceding examples that the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
It does support ORDER BY operations, BLOB columns, and basically all data types including spatial data types (see Section 11.4.1, “Spatial Data Types”). The AUTO_INCREMENT column can have either a unique or nonunique index. Attempting to create ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
You need only the SELECT privilege for any columns that are only read, such as those named in the WHERE clause. Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
To use a WHERE clause with SHOW CHARACTER SET, you would refer to those column names. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of ...
https://dev.mysql.com/doc/refman/5.7/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
If you have a multiple-column index, specify the index column values as a comma-separated list. Either specify values for all the columns in the index, or specify values for a leftmost prefix of the index columns. Suppose that an index my_idx ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table has these columns: POOL_ID The buffer pool ID. This column is applicable only to pages with a PAGE_TYPE value of INDEX. This column is applicable only to pages with a PAGE_TYPE value of INDEX. This column is applicable ... The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table has these columns: KEY The name designating an item of metadata for an InnoDB table containing a FULLTEXT index. The values for this column might change, depending on the needs for performance tuning and debugging for ...