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/if.html
Note There is also an IF() function, which differs from the IF statement described here. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 10.9.3, “Optimizer Hints”. They also work with multi-table DELETE ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
The Index Merge access method retrieves rows with multiple range scans and merges their results into one. This access method merges index scans from a single table only, not scans across multiple tables. The merge can produce unions, intersections, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-character-sets-table.html
Notes Character set information is also available from the SHOW CHARACTER SET statement. 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. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-collation-character-set-applicability-table.html
Notes The COLLATION_CHARACTER_SET_APPLICABILITY columns are equivalent to the first two columns displayed by the SHOW COLLATION statement. The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-collations-table.html
Notes Collation information is also available from the SHOW COLLATION statement. The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-extensions-table.html
The COLUMNS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about column attributes defined for primary and secondary storage engines. The COLUMNS_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
Notes In SHOW COLUMNS, the Type display includes values from several different COLUMNS columns. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-failed-login-attempts-table.html
Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and the CONNECTION_CONTROL plugin must be activated or the table contents are always empty. This table provides information about the ...