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/temporary-table-problems.html
It may occur for temporary tables created outside stored functions and referred to across multiple calling and callee functions. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
When validate_password_check_user_name is enabled, it has these effects: Checking occurs in all contexts for which validate_password is invoked, which includes use of statements such as ALTER USER or SET PASSWORD to change the current user's ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
A simple character set requires only a configuration file, whereas a complex character set requires C source file that defines collation functions, multibyte functions, or both. If the character set requires string collating functions, see Section ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
The WEIGHT_STRING() function can be used to see the weights for the characters in a string. To add a collation that does require recompiling (as implemented by means of functions in a C source file), use the instructions in Section 10.13, “Adding ... A collation is a set of rules that defines how to compare and sort character ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
To disable myevent, use this ALTER EVENT statement: ALTER EVENT myevent DISABLE; The ON SCHEDULE clause may use expressions involving built-in MySQL functions and user variables to obtain any of the timestamp or interval values which it contains.
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
With the mysql_info() C API function, you can find out how many rows were copied by ALTER TABLE. Running ALTER TABLE tbl_name FORCE on an InnoDB table performs the same function. ALTER TABLE tbl_name [alter_option [, alter_option] ...] ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
There are exceptions when you cannot switch the replication format at runtime: From within a stored function or a trigger. With mixed replication, temporary tables are usually logged; exceptions happen with loadable functions and with the UUID() ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
For stored procedure, stored function, and trigger objects, the relevant sql_mode value is the one in effect when the object was created. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() function.
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
One context in which you may see binary is for compression functions, which return binary strings as a general rule: mysql> SELECT COLLATION(COMPRESS('x')); +--------------------------+ | COLLATION(COMPRESS('x')) | +--------------------------+ | ...