PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
A generated column in a view is considered updatable because it is possible to assign to it. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. For example, if a view is defined as SELECT * on a ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
Table 14.22 cache_policies Columns Column Description policy_name Name of the cache policy. Table 14.23 config_options Columns Column Description Name Name of the memcached-related configuration option. The following configuration options are ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. If an application stores values from a function such as MD5() or SHA1() that returns a string of hex digits, more efficient storage and comparisons ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
Table data might be compressed, either for a column or an entire row, complicating the calculation of storage requirements for a table or column. This figure excludes BLOB or TEXT columns, which contribute only 9 to 12 bytes toward this size. For ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Inserting NULL to generate AUTO_INCREMENT values ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
FOR EXPORT is run, InnoDB generates a .cfg metadata file in the schema directory of the table. Note If you are importing a table from an encrypted tablespace, InnoDB generates a .cfp file in addition to a .cfg metadata file. FOR EXPORT is run, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-event-tables.html
For each event type, the _current, _history, and _history_long tables have the same columns. For _history_long, when the table becomes full, the oldest row is discarded when a new row is added, regardless of which thread generated either row. After ... For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
In the Default column, PREFIX stands for the value of the CMAKE_INSTALL_PREFIX option, which specifies the installation base directory. -DCMAKE_BUILD_TYPE=type The type of build to produce: RelWithDebInfo: Enable optimizations and generate debugging ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
} export_options: [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] SELECT is used to retrieve rows selected from one or more tables, and can ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
No InnoDB table definition may contain a foreign key reference to a user-partitioned table; no InnoDB table with user-defined partitioning may contain columns referenced by foreign keys. ORDER BY column statement run against a partitioned table ...