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/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table option. 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 */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 1 row in set (0.01 sec) To change the storage type of an individual column, you can use ALTER TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
To prevent various error conditions or corruptions, InnoDB checks file format compatibility when it opens a file (for example, upon first access to a table). The file format management capability in InnoDB 1.0 and higher (tablespace tagging and ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
The data types may differ from what you expect them to be based on a CREATE TABLE statement because MySQL sometimes changes data types when you create or alter a table. Key Whether the column is indexed: If Key is empty, the column either is not ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
COMPRESS_TIME The total time in seconds used for compressing data in this index. UNCOMPRESS_TIME The total time in seconds used for uncompressing data in this index. For a compressed InnoDB table, both the table data and all the secondary indexes ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
max_latency The maximum single wait time of timed statements for the host. total_latency The total wait time of timed statements for the host. lock_latency The total time waiting for locks by timed statements for the host. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-latency.html
max_latency The maximum single wait time of timed statements for the user. total_latency The total wait time of timed statements for the user. lock_latency The total time waiting for locks by timed statements for the user. The ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
Adding or dropping a secondary index on a virtual generated column is an in-place operation. For more information, see Section 13.1.18.8, “Secondary Indexes and Generated Columns”. However, later reads from the table might report warnings or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
The timeout is applied with approximately 100 ms resolution, starting with a 100 ms delay; for each subsequent attempt, the length of this period is doubled until it reaches ConnectBackoffMaxTime milliseconds, up to a maximum of 100000 ms (100s).