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/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed ...For information about the conditions under which this occurs for the server logs and how to control it, see Section 6.1.2.3, “Passwords and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. The metadata requirements mean that the return values of the USER(), CURRENT_USER(), SESSION_USER(), SYSTEM_USER(), DATABASE(), and ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
-DWITH_ZLIB=zlib_type Some features require that the server be built with compression library support, such as the COMPRESS() and UNCOMPRESS() functions, and compression of the client/server protocol. The CMake program provides a great deal of ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html
You can always store an exact integer value in a BIGINT column by storing it using a string. In this case, MySQL performs a string-to-number conversion that involves no intermediate double-precision representation. This means that if you multiply ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html
The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ''. For example, the following statements are completely different: mysql> INSERT INTO my_table ...In ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
InnoDB API functions are passed to the InnoDB memcached engine as callback functions. InnoDB API functions access the InnoDB tables directly, and are mostly DML operations with the exception of TRUNCATE TABLE. The following configuration options are ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
--remap-column takes as its argument a string having the format db.tbl.col:fn:args, where db, tbl, and col are, respectively, the names of the database, table, and column, fn is the name of a remapping function, and args is one or more arguments to ...There are no user-visible changes in functionality directly associated with this performance enhancement; it is part of work done to improve undo long handling in support of partial local checkpoints in NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-security.html
MySQL Enterprise Edition includes a suite of masking and de-identification functions that perform subsetting, random generation, and dictionary replacement to de-identify strings, numerics, phone numbers, emails and more. These functions enable ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
log_bin_trust_function_creators: If equal to 0 (default), then when --log-bin is used, stored function creation is allowed only to users having SUPER privilege and only if function created does not break binary logging. Set to empty string to ...