Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
ALTER EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY DO TRUNCATE TABLE myschema.mytable; Specify the options in an ALTER EVENT statement only for those characteristics that you want to change; omitted options keep their existing ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
If expression evaluation causes truncation or provides incorrect input to a function, the ALTER TABLE statement terminates with an error and the DDL operation is rejected. ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
(SystemV Unix systems and perhaps others are subject to this problem.) If you are using MySQL Replication, be aware that a password used by a replica as part of CHANGE REPLICATION SOURCE TO is effectively limited to 32 characters in length; if the ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE TABLE. The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a Transaction_payload_event). Compressed ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
The MySQL server then tells InnoDB to complete any prepared transactions that were successfully written to the to the binary log, and truncates the binary log to the last valid position. The binary log contains “events” that describe database ...
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
For example, you may still use DROP to drop the table, and TRUNCATE TABLE to empty the table. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
If expression evaluation causes truncation or provides incorrect input to a function, the CREATE TABLE statement terminates with an error and the DDL operation is rejected. Values of a generated column are computed from an expression included in the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
The maximum MAX_ROWS value is 4294967295; larger values are truncated to this limit. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] ...