Search Results
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
Table 8.13 System and Status Variables for Session Reuse System Variable Name Corresponding Status Variable Name ssl_session_cache_mode Ssl_session_cache_mode ssl_session_cache_timeout Ssl_session_cache_timeout Note When the value of the ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-validation.html
MySQL supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the server terminates with an exit ...If an error is found, the server displays a diagnostic message and terminates with an exit code of ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
Test Suite Session State Tracker Support The mysqltest program has disable_session_track_info and enable_session_track_info commands that control whether session tracker notifications occur. A client can enable these trackers to receive notification ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html
MySQL lets you use different sql_mode settings to tell the server the type of SQL syntax to support. For example, you might use the ANSI SQL mode to ensure MySQL correctly interprets the standard SQL concatenation operator, the double bar (||), in ... SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
MySQL ignores the value of the sql_mode system variable; in particular, strict SQL mode does not matter. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. In some cases, MySQL silently ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
If you enable setuid() core files for the current user, they are generated using mode 600 and are owned by the superuser. Note MySQL 8.4 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For ...
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
A server that participates in a group in single-primary mode should use skip_replica_start=ON. START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group replication. This statement requires the ...