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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_INDEX_TABLE table has these columns: WORD A ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
The INNODB_SYS_TABLES table has these columns: TABLE_ID An identifier for the InnoDB table. The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR). Use the INFORMATION_SCHEMA COLUMNS ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
After doing substantial insert, update, or delete operations on columns that are part of a FULLTEXT index in an InnoDB table. After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
However, if an AUTO_INCREMENT value is generated for any partitioning column then all partitions are locked. An UPDATE prunes locks only for tables on which no partitioning columns are updated. ON DUPLICATE KEY UPDATE is pruned as long as no ...In ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
The number of indexed columns in a table The number of partitions. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
The INSTRUMENTED and HISTORY column values for new threads are determined by the contents of the setup_actors table. For information about how to use the setup_actors table to control these columns, see Section 25.4.6, “Pre-Filtering by Thread”.
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
This is where the privilege columns in the grant tables come into play. These privileges can come from any of the user, db, tables_priv, columns_priv, or procs_priv tables. (You may find it helpful to refer to Section 6.2.3, “Grant Tables”, ...