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/command-line-options.html
The second instructs mysql to prompt for the password value and to use test as the default database. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as ...An ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
These variables have three possible values, which differ as follows: When the variable is set to nulls_equal, all NULL values are treated as identical (that is, they all form a single value group). Setting the global value affects statistics ...When ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
For batched_key_access to have any effect when set to on, the mrr flag must also be on. The derived_merge flag controls whether the optimizer attempts to merge derived tables and view references into the outer query block, assuming that no other ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
16.1.7.3.2.1 Skipping Transactions With SET GLOBAL sql_slave_skip_counter When you have assessed the failing transaction for any other appropriate actions as described previously (such as security considerations), count the number of events that you ...Before skipping a transaction, ensure that the replication I/O thread is stopped as well as the replication SQL ... If replication stops due to an issue ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ...For information about using result set metadata to distinguish them from other strings, see C API Basic Data ... An ENUM is a string object with a value chosen ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
Files created using mysql_ssl_rsa_setup are owned by the user who invoked that program. For some distribution types, such as RPM and DEB packages, mysql_ssl_rsa_setup invocation occurs during data directory initialization. Automatic SSL and RSA File ...Important Server autogeneration and mysql_ssl_rsa_setup help lower the barrier to using SSL by making it easier to generate the required ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
Before querying any of them, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). YourSQL','In the following database ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
Beginning with NDB 7.5.4, you can obtain such information, using the mysql client, from the table_distribution_status, table_fragments, table_info, and table_replicas tables in the ndbinfo database. --context, -x Show additional contextual ...For ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
For HASH partitioning, the user-supplied expression must evaluate to an integer value. With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be ...