PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html
Variables that have a type of “string” take a string value. Variables that have a type of “numeric” take a numeric value. Variables that have a type of “boolean” can be set to 0, 1, ON or OFF. Many server system variables are dynamic ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
The functions continue to be available in later releases if they have been installed, but they are deprecated. MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of ... In ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
This example works with both the component function and the legacy function: SET @priv1 = create_asymmetric_priv_key('RSA', 2048); SELECT create_asymmetric_priv_key('RSA', 2048) INTO @priv2; INSERT INTO t (key_col) ... To use MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-syslog.html
It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like systems). On Windows, error messages written to the Event Log within the Application log have these characteristics: ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
Although ON and OFF have numeric equivalents, the value displayed for event_scheduler by SELECT or SHOW VARIABLES is always one of OFF, ON, or DISABLED. This table can be queried to obtain information about scheduled events which have been defined ... Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
MySQL Events have the following major features and properties: In MySQL, an event is uniquely identified by its name and the schema to which it is assigned. A user may include statements in an event's action which require privileges that the user ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
If you have a problem with indexes not being used when you believe that they should be, run ANALYZE TABLE to update table statistics, such as cardinality of keys, that can affect the choices the optimizer makes. Decimal numbers less than 1000 have ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name } format_name: { TRADITIONAL | JSON | TREE } explainable_stmt: { select_stmt | TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Do stored procedures have a statement for raising application errors? A.4.13. Do stored procedures have a statement for raising application errors? Yes. If replication or binary logging in general (for the purpose of point-in-time recovery) is ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
This user must have been created on the remote server, and must have suitable privileges to perform the required actions (SELECT, INSERT, UPDATE, and so forth) on the remote table. The name of the local and the remote table do not have to match. To ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...