MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 291 to 300 of 797 total results

https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html

When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...

13.7.1.2 CREATE USER Statement

https://dev.mysql.com/doc/refman/5.7/en/create-user.html

CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... It enables authentication, SSL/TLS, ...

6.2.4 Specifying Account Names

https://dev.mysql.com/doc/refman/5.7/en/account-names.html

MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...

6.4.6.4 MySQL Enterprise Firewall Reference

https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html

When enabled, the firewall bases operational decisions on the cached data. The firewall database can be the mysql system database or a custom schema (see Installing MySQL Enterprise Firewall). For information about MySQL Enterprise Firewall ...

6.4.4.12 Keyring System Variables

https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html

These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin Installation”). keyring_aws_cmk_id Command-Line Format --keyring-aws-cmk-id=value Introduced 5.7.19 System Variable ...

1.6.3.4 ENUM and SET Constraints

https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html

ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 11.3.5, “The ENUM Type”, and Section 11.3.6, “The SET Type”. Unless strict mode is disabled (not recommended, but see ...

6.4.6.3 Using MySQL Enterprise Firewall

https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html

Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 6.4.6.2, “Installing or Uninstalling MySQL Enterprise Firewall”. Also, MySQL Enterprise Firewall does not work together with the query cache; ...

13.4.2.2 CHANGE REPLICATION FILTER Statement

https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html

Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD ...

13.6.7.2 DECLARE ... HANDLER Statement

https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html

statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...

2.5.7.2 More Topics on Deploying MySQL Server with Docker

https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html

A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are limited to: /usr/bin/my_print_defaults /usr/bin/mysql /usr/bin/mysql_config /usr/bin/mysql_install_db ...

Displaying 291 to 300 of 797 total results