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/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 ...IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. If the constraint is a foreign key, then this is the column of the foreign key, not the column that the foreign key references.
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. If no column is given, all matching columns and column types in the table are shown. The output displays only the names of those ...The same information can be obtained by using those statements ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. This phenomenon can lead to different results for a given TIMESTAMP ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. However, this conversion is subject to the following exceptions: When you compare two columns When ...
https://dev.mysql.com/doc/refman/5.7/en/choosing-types.html
For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. All basic calculations (+, -, *, and /) with DECIMAL columns are done with precision of 65 decimal (base 10) digits. For optimum ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
The server now requires account rows in the mysql.user system table to have a nonempty plugin column value and disables accounts with an empty value. ALTER TABLE now supports a RENAME INDEX clause that renames an index. These InnoDB enhancements ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
group_replication_auto_increment_increment: Determines interval between successive column values for transactions executing on this server. Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and ...