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/select.html
You can refer to a table within the default database as tbl_name, or as db_name.tbl_name to specify a database explicitly. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
In addition to storing metadata about database objects in the data dictionary, MySQL stores it in serialized form. Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. Client users can obtain the RSA public key two ways: The database administrator can provide ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
MySQL maps certain data types used by other SQL database vendors to MySQL types. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. Removal of the package does not delete the existing database information, only the server, binaries and ... You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the ...
https://dev.mysql.com/doc/refman/8.0/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The guidelines cover SQL operations that read and write data, the ...The ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
It connects to a current MySQL (not NDB Cluster) database and creates a report on how much space that database would require if it used the NDB storage engine. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
To generate a dump file, name the sys schema explicitly on the command line using either of these commands: mysqldump --databases --routines sys > sys_dump.sql mysqlpump sys > sys_dump.sql To reinstall the schema from the dump file, use this ...Most ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
Only statements that modify databases or tables count against the update limit. One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of ...