Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-list-add.html
Example mysql> SELECT @@sql_mode; +----------------------------------------+ | @@sql_mode | +----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES | +----------------------------------------+ mysql> SET @@sql_mode = ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-stack.html
row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": "8.4.0-tr", "mysql_user": "root@localhost","events": [{"nesting_event_id": "0", "event_id": "10", ... Returns ...
https://dev.mysql.com/doc/refman/8.4/en/sys-quote-identifier.html
Example mysql> SELECT sys.quote_identifier('plain'); +-------------------------------+ | sys.quote_identifier('plain') | +-------------------------------+ | `plain` | +-------------------------------+ mysql> SELECT sys.quote_identifier('trick`ier'); ... Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-elements.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; Note If you do not load all the monitoring tables, ...
https://dev.mysql.com/doc/refman/8.4/en/transport-protocols.html
This section describes how to select these protocols, and how they are similar and different. Transport Protocol Selection Transport Support for Local and Remote Connections Interpretation of localhost Encryption and Security Characteristics ... For ...
https://dev.mysql.com/doc/refman/8.4/en/tuning-trace-purging.html
A subsequent SELECT from the OPTIMIZER_TRACE table returns the first limit traces of the offset oldest stored traces (if offset >= 0), or the first limit traces of the -offset newest stored traces (if offset < 0). For example: SET ...Thus, if a ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
You can determine the default storage engine on a MySQL Server instance by issuing the following statement: mysql> SELECT @@default_storage_engine; +--------------------------+ | @@default_storage_engine | +--------------------------+ | InnoDB | ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-restrictions.html
Using such functions in a subquery of these statements (to select rows) is permitted. A maximum of 127 windows is supported for a given SELECT. Note that a single query may use multiple SELECT clauses, and each of these clauses supports up to 127 ...