PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. Account names appear in SQL statements such as CREATE USER, GRANT, and SET ...This section describes the syntax for account names, including special values and wildcard ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/identifier-mapping.html
If you are using tablespaces with InnoDB, then the specific tablespace files you create are used instead. MySQL encodes any characters that are problematic in the corresponding file system objects when it creates database directories or table files: ... There is a correspondence between database and table identifiers and names in the file ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If the server uses temporary ... If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra ...
https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html
DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the CREATE TABLE statement is supported on Windows for InnoDB tables only, as described in Section 17.6.1.2, “Creating Tables Externally”. For MyISAM and other storage engines, the ...File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir ... The following restrictions apply to use ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with MySQL Enterprise Firewall (see Section 8.4.7, “MySQL Enterprise Firewall”). These tables are available only if the appropriate firewall plugins are enabled.
https://dev.mysql.com/doc/refman/8.0/en/general-information-schema-tables.html
The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-administrable-role-authorizations-table.html
The ADMINISTRABLE_ROLE_AUTHORIZATIONS table (available as of MySQL 8.0.19) provides information about which roles applicable for the current user or role can be granted to other users or roles. The ADMINISTRABLE_ROLE_AUTHORIZATIONS table has these ...GRANTEE The user name part of the account to which the role is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-applicable-roles-table.html
The APPLICABLE_ROLES table (available as of MySQL 8.0.19) provides information about the roles that are applicable for the current user. The APPLICABLE_ROLES table has these columns: USER The user name part of the current user account. IS_GRANTABLE ...GRANTEE The user name part of the account to which the role is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...