Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
If you normally leave password expiration disabled (that is, audit_log_password_history_keep_days has a value of 0), it is possible to perform an on-demand cleanup operation by temporarily assigning the variable a value greater than zero. Unless ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
The latter name choice leaves room for future expansion of possible digest lengths without changing the plugin name. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
If you are using statement-based replication and temporary tables, it is possible for a CHANGE REPLICATION SOURCE TO statement following a STOP REPLICA statement to leave behind temporary tables on the replica. ] CHANGE REPLICATION SOURCE TO changes ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
Several questions about character set and collation handling for client connections can be answered in terms of system variables: What character set are statements in when they leave the client? The server takes the character_set_client system ... A ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
Permitted protocols should be chosen such as not to leave “holes” in the list. This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-primary-key.html
If you are using a nontransactional storage engine, MySQL stops processing the statement at the row for which the error occurred and leaves any remaining rows unprocessed. Normally, errors occur for data-change statements (such as INSERT or UPDATE) ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
Typically, you leave this variable enabled during normal operation to enforce referential integrity. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related ...