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/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
Creating such tables also requires the option values innodb_file_format=barracuda and innodb_file_per_table=true.) In this case, enabling the innodb_large_prefix option enables you to index a maximum of 1024 or 768 characters for utf8mb3 or utf8mb4 ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
This row-by-row calculation is what you get with the EXTENDED clause, with InnoDB and all other storage engines other than MyISAM, and with MyISAM tables not created with the CHECKSUM=1 clause. For MyISAM tables created with the CHECKSUM=1 clause, ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. MySQL requires that foreign key columns be indexed; if you create a table with a foreign key constraint but no index on a given column, an ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT '0.00' ); SERIAL DEFAULT VALUE is a special case. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this case, i has ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. If this mode is enabled at the time that a table is created, TIMESTAMP columns are created as DATETIME columns. The ...
https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6)); The fsp value, if given, must be in the range 0 to 6. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
The minimum and maximum word length full-text parameters apply to FULLTEXT indexes created using the built-in FULLTEXT parser and MeCab parser plugin. Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_CREATE_RATE The number of pages created per second (pages created since the last printout / time elapsed). The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
Most indexes created implicitly by InnoDB have consistent names but the index names are not necessarily unique. For GEN_CLUST_INDEX indexes, this value is 0 because the index is created using an artificial value rather than a real table column. Any ... The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the information in the internal SYS_INDEXES table in the InnoDB data ...