PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
The FILES table has these columns: FILE_ID For InnoDB: The tablespace ID, also referred to as the space_id or fil_space_t::id. This is the same as the value shown for the id column in the ndbinfo.dict_obj_info table and the log_id column in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
This principle applies to the INFORMATION_SCHEMA tables shown in the following table, which shows the columns for which a constant lookup value enables the server to avoid a directory scan. The following list indicates how the preceding optimization ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
Each row in the index node contains the values of the (user-specified or system-generated) primary key and all the other columns of the table. The pointer is in fact the value of the primary key of the table, which is used to access the clustered ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
“Record” and “row” are synonymous, as are “field” and “column.” The initial part of the table description contains these values: MyISAM file Name of the MyISAM (index) file. Auto increment key, Last value The key number associated ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have. In other words, every unique key on the table must ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
SET column values that consist of multiple set members are specified with members separated by commas (,). For example, a column specified as SET('one', 'two') NOT NULL can have any of these values: '' 'one' 'two' 'one,two' A SET column can have a ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM Tables CHECK TABLE Output CHECK TABLE returns a result set with the columns shown in the ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds precision. (This differs from the standard SQL default of 6, for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
Tags are matched based on the tag or attribute name and the column name. User variables can be especially useful when you want to insert data from an XML file into table columns whose names do not match those of the XML fields. You can work around ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE COLUMNS, see Section 22.2.3.1, “RANGE COLUMNS partitioning”. Similar to partitioning ... This section discusses the types of partitioning which are available in MySQL ...