Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
authentication-kerberos-mode Kerberos implementation SSPI Acceptable values are "SSPI" (default) or "GSSAPI". It has no effect if ssl-mode=DISABLED, and overrides (disables) the related NO_TLS_X_Y connection options such as NO_TLS_1_2. ssl-mode SSL ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
When using -binlog_format=mixed, DML operations that read data from grant tables are written to the binary log as row events to make the operations safe for mixed-mode replication. Note Direct modification of grant tables using statements such as ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
This type of repair is like that done by myisamchk --safe-recover. Caution Use the USE_FRM option only if you cannot use regular REPAIR modes. For a MyISAM table, if you do not get OK, you should try repairing it with myisamchk --safe-recover. With ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
Batch mode can also be useful while you're developing a query, particularly for multiple-line statements or multiple-statement sequences. The default output format is different (more concise) when you run mysql in batch mode than when you use it ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
For this reason, replication of such a statement may not be safe when STATEMENT mode is in use. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes ...In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
The failover support is configured by the following connection properties (their functions are explained in the paragraphs below): failOverReadOnly secondsBeforeRetrySource queriesBeforeRetrySource retriesAllDown autoReconnect autoReconnectForPools ...A failover happens when connection-related errors occur for an underlying, active ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
The failover support is configured by the following connection properties (their functions are explained in the paragraphs below): failOverReadOnly secondsBeforeRetrySource queriesBeforeRetrySource retriesAllDown autoReconnect autoReconnectForPools ...A failover happens when connection-related errors occur for an underlying, active ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-temptables.html
In statement-based replication mode, temporary tables are replicated except in the case where you stop the replica server (not just the replication threads) and you have replicated temporary tables that are open for use in updates that have not yet ...When binlog_format is set to STATEMENT, operations on temporary tables are logged on the source and replicated on the replica, provided that the statements involving temporary tables can be logged safely using statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...