PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/union.html
This kind of ORDER BY cannot use column references that include a table name (that is, names in tbl_name.col_name format). Extra columns can provide other identifying information as well, such as a string that indicates a table name. [UNION [ALL | ...
https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html
mysql_upgrade also performs other functions; see Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables” for details. It is preferable to use the MySQL Yum repository or MySQL SLES Repository to upgrade MySQL on RPM-based platforms.
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). This section describes how to install the validate_password ...
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. In a WITH CHECK OPTION clause for an updatable view, the LOCAL and CASCADED keywords ...It ...
https://dev.mysql.com/doc/refman/5.7/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/windows-installation-layout.html
All of the files are located within this parent directory, using the structure shown in the following table. Table 2.4 Default MySQL Installation Layout for Microsoft Windows Directory Contents of Directory Notes bin mysqld server, client and ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. For more information about mysqlshow, see Section 4.5.7, “mysqlshow — Display ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...