PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
For storage engines that support nonspatial indexing of spatial columns, the engine creates a B-tree index. For more information on indexing spatial columns, see Section 13.1.14, “CREATE INDEX Statement”. To drop spatial indexes, use ALTER TABLE ... For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
Normally, column labels are the names of the columns you fetch from database tables. If you're retrieving the value of an expression rather than a table column (as in the example just shown), mysql labels the column using the expression itself.
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
The table has the following columns (with the corresponding Information Schema MYSQL_FIREWALL_USERS table having similar but not necessarily identical columns): USERHOST The account profile name. The table has the following columns (with the ...When ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
The sizes of the identifier string columns in the grant tables are measured in characters. You can use multibyte characters without reducing the number of characters permitted for values stored in these columns. For information about the maximum ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-being-deleted-table.html
The INNODB_FT_BEING_DELETED table has these columns: DOC_ID The document ID of the row that is in the process of being deleted. This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table has these columns: DOC_ID The document ID of the newly deleted row. This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the ... The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table has these columns: WORD A word extracted from the text of a newly inserted row. This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by ... The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
The INNODB_LOCKS table has these columns: LOCK_ID A unique lock ID number, internal to InnoDB. To obtain details about the transaction, join this column with the TRX_ID column of the INNODB_TRX table. Use the INFORMATION_SCHEMA COLUMNS table or the ... The INNODB_LOCKS table provides information about each lock that an InnoDB transaction has requested but not yet acquired, and each lock that a transaction holds that is blocking another ...