PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
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/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/events-privileges.html
Users' EVENT privileges are stored in the Event_priv columns of the mysql.user and mysql.db tables. In both cases, this column holds one of the values 'Y' or 'N'. For a schema-level EVENT privilege, GRANT creates a row in mysql.db and sets that ...
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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). TYPE A collection of bit flags with information about the foreign key ... The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
The INNODB_BUFFER_PAGE_LRU table has the same columns as the INNODB_BUFFER_PAGE table, except that the INNODB_BUFFER_PAGE_LRU table has an LRU_POSITION column instead of a BLOCK_ID column. The definition for this page is the same as for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
For mysqldump --tab, the server by default writes table data to .txt files one line per row with tabs between column values, no quotation marks around column values, and newline as the line terminator. INTO OUTFILE.) To enable data files to be ...