PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
Column c1 uses disk-based storage, since this is the default for the table (determined by the table-level STORAGE DISK clause in the CREATE TABLE statement). This occurs because the order in which the rows are numbered depends on the specific ...For ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
This enables MySQL to obfuscate passwords prior to storing them in the mysql.user system table. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. This is not due to any limit imposed by the MySQL ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this section. This means that changing the logging format on a replication source server does ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
This causes the server to use the given settings for all applications that do not make other arrangements. This causes the server to use the given settings as the defaults for all applications, without having to specify them at server startup. To ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state. For large tables, this could take a long time, thus you would only ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
(Under Windows, this restriction does not apply, although you must refer to databases and tables using the same lettercase throughout a given query. Discuss this with the administrator or see Section 6.2, “Access Control and Account Management”.
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
MySQL uses this log to recover from a crash occurring in the middle of a partitioning metadata operation. This is a binary file; it is not intended to be human-readable, and you should not attempt to modify its contents in any way. Thus, it is ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. This optimization can be used only by the NDB storage engine. For example, in a my.cnf file, use these lines: [mysqld] ...In such cases, the ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server determines which function to use in cases when functions of different types exist with a ...