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/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/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
As of MySQL 5.7.7, a table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
For example, the storage format for temporal types such as TIME, DATETIME, and TIMESTAMP changed in MySQL 5.6 prior to MySQL 5.6.5, so if a 5.5 table is upgraded to MySQL 5.6, the checksum value may change. [QUICK | EXTENDED] CHECKSUM TABLE reports ...
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of digits following the decimal point for fractional parts of seconds. MySQL supports SQL data types in several categories: ...
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Where can I find the documentation for MySQL 5.7 triggers? A.5.2. Is there a way to view all triggers in a given ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
The insert_id and timestamp options are not propagated to the data provider. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a ...