PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue, a temporary table is created. This section discusses optimizations that can be ...
https://dev.mysql.com/doc/refman/8.0/en/windows-and-ssh.html
Log in to your server with the SSH session you just created. Create a new file in Windows and link to MySQL using the ODBC driver the same way you normally do, except type in localhost for the MySQL host server, not yourmysqlservername. This ...
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
If necessary, initialize the data directory and create the MySQL grant tables. If you install MySQL using MySQL Installer, the root user is created automatically with the password you supplied. GUI tools exist that perform most of the tasks ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
Specifically, do not permit User to be empty (which creates an anonymous-user account), and do not permit pattern characters or netmask notation in Host values. Applications can use the following guidelines to perform SQL-based auditing that ties ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-unicode-uca.html
It is not possible to create user-defined UCA collations for utf16le; there is no utf16le_unicode_ci collation that would serve as the basis for such collations. This section describes how to add a UCA collation for a Unicode character set by ...
https://dev.mysql.com/doc/refman/8.0/en/administrative-connection-interface.html
The create_admin_listener_thread system variable enables DBAs to choose at startup whether the administrative interface has its own separate thread. (This is the case if any admin_tls_xxx or admin_ssl_xxx system variable is set to a value different ... As mentioned in Connection Volume Management, to allow for the need to perform administrative operations even when max_connections connections are already established on the interfaces used for ordinary connections, the MySQL server permits a single administrative connection to users who have the CONNECTION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.0/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.