PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/alter-table-generated-columns.html
As of MySQL 5.7.10, 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 ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
If you set audit_log_rotate_on_size to a value that is not a multiple of 4096, it is truncated to the nearest multiple. Unless those objects are installed, the audit_log plugin operates in legacy mode. Audit Log Tables MySQL Enterprise Audit uses ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/change-master-to.html
The password used for a replication user account in a CHANGE MASTER TO statement is limited to 32 characters in length; prior to MySQL 5.7.5, if the password was longer, the statement succeeded, but any excess characters were silently truncated. ] ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/create-table-generated-columns.html
As of MySQL 5.7.10, 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 ...