PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW sys.session; mysql> SHOW CREATE FUNCTION sys.format_bytes; However, those statements display the definitions in ...
https://dev.mysql.com/doc/refman/5.7/en/two-digit-years.html
Some functions like MIN() and MAX() convert a YEAR to a number. This means that a value with a 2-digit year does not work properly with these functions. Date values with 2-digit years are ambiguous because the century is unknown. Such values must ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
To be on the safe side, assume that strings are compared as strings and use the appropriate string functions if you want to compare a temporal value to a string. You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-elements.html
A set of loadable functions provides an SQL-level API for manipulating and inspecting the list of server version tokens maintained by the plugin. The SUPER privilege is required to call any of the Version Token functions. Version Tokens is based on ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
A reference to the CURRENT_USER or CURRENT_USER() function is equivalent to specifying the current client's user name and host name literally. MySQL account names consist of a user name and a host name, which enables creation of distinct accounts ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The number member of the MY_CHARSET_INFO data structure returned by the mysql_get_character_set_info() C API function. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
See Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. ALTER {DATABASE | ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
As of MySQL 5.7.10, if expression evaluation causes truncation or provides incorrect input to a function, the ALTER TABLE statement terminates with an error and the DDL operation is rejected. ALTER TABLE operations permitted for generated columns ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
In one case only, the account may be specified with the USER() function: ALTER USER USER() IDENTIFIED BY 'auth_string'; This syntax enables changing your own password without naming your account literally. ALTER USER [IF EXISTS] user [auth_option] ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...