PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/libmysqld.html
To change a threaded application to use the embedded library, you normally only have to add calls to the following functions. Table 27.2 MySQL Embedded Server Library Functions Function When to Call mysql_library_init() Call it before any other ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
The value is one of 'EVENT' (Event Scheduler event), 'FUNCTION' (stored function), 'PROCEDURE' (stored procedure), 'TABLE' (base table), or 'TRIGGER' (trigger). The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...Note ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html
5.5.4.3.2 Rewriter Query Rewrite Plugin Procedures and Functions Rewriter plugin operation uses a stored procedure that loads the rules table into its in-memory cache, and a helper loadable function. The function is intended to be invoked by the ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
A similar statement, SHOW FUNCTION STATUS, displays information about stored functions (see Section 13.7.5.20, “SHOW FUNCTION STATUS Statement”). The LIKE clause, if present, indicates which procedure or function names to match. row ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. validate_password implements a VALIDATE_PASSWORD_STRENGTH() SQL function that assesses the strength of ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. For example, this occurs when the statement creating a view uses the UUID() function. When running in MIXED logging format, the server ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. MySQL provides ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
You can retrieve the most recent automatically generated AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. These functions are connection-specific, so their return values are not affected by another ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
If the value is func, the value used is the result of some function. To see which function, use SHOW WARNINGS following EXPLAIN to see the extended EXPLAIN output. The function might actually be an operator such as an arithmetic operator. The ...