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/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/commit.html
Note Within all stored programs (stored procedures and functions, triggers, and events), the parser treats BEGIN [WORK] as the beginning of a BEGIN ... If a SELECT statement within a transaction calls a stored function, and a statement within the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
How is InnoDB data-at-rest encryption different from encryption functions MySQL already provides? A.17.11. How is InnoDB data-at-rest encryption different from encryption functions MySQL already provides? There are symmetric and asymmetric ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
Note It is not possible to issue FLUSH statements within stored functions or triggers. However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. Note The DES_ENCRYPT() and DES_DECRYPT() ...| ...
https://dev.mysql.com/doc/refman/5.7/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. Applications that require geometically valid geometries should check them using the ST_IsValid() function.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
As long as the remaining members are a majority of the group they can elect a new primary and continue to function as a group. You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
To enable or disable it explicitly, invoke the mysql_options() C API function to disable or enable the MYSQL_OPT_LOCAL_INFILE option. When you use these utilities to handle the data, MySQL Shell provides additional functions such as input ... The ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
Using MySQL facilities like the BENCHMARK() function, you can get an idea about what helps in your own situation. MySQL replaces subqueries of the following form with an index-lookup function, which EXPLAIN describes as a special join type ...