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/no-login-pluggable-authentication.html
DBAs can use this behavior to provide access to confidential or sensitive data that is exposed only through well-controlled interfaces. The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary ...
https://dev.mysql.com/doc/refman/5.7/en/null-values.html
The NULL value means “no data.” NULL can be written in any lettercase. Treatment of \N as a synonym for NULL in SQL statements is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0; use NULL instead. Be aware that the NULL value is ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a ...
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
The “enabled” form of the option may be specified in any of these ways: --column-names --enable-column-names --column-names=1 The values ON, TRUE, OFF, and FALSE are also recognized for boolean options (not case-sensitive). Some options are ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
For example, when using a case-sensitive collation, 'and' sorts before 'Andersen', but when using a collation that is case-insensitive, the reverse is true. Range columns partitioning is similar to range partitioning, but enables you to define ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 5.7. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
Server plugins must be loaded into the server before they can be used. It is also possible to control the activation state of loaded plugins at startup, and to unload them at runtime. While a plugin is loaded, information about it is available as ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE.
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
If either argument is a binary string, the arguments are handled in case-sensitive fashion as binary strings. Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches ...