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/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 ...The ...Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ ...
https://dev.mysql.com/doc/refman/8.0/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. Duplicate values in the definition cause a warning, or an error if strict SQL mode is ...A ...SET column values that consist of multiple set members are specified with members separated by commas ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-event-reports.html
By default, the cluster log is saved to a file named ndb_node_id_cluster.log, (where node_id is the node ID of the management server) in the management server's DataDir. Cluster logging information can also be sent to stdout or a syslog facility in ...Each reportable event can be distinguished according to three different criteria: Category: This can be any one of the following values: STARTUP, SHUTDOWN, STATISTICS, CHECKPOINT, NODERESTART, CONNECTION, ERROR, or ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-repair.html
When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field separators, escaped fields (matching or missing quotation marks), the correct number of fields compared to the table definition and the ...
https://dev.mysql.com/doc/refman/8.0/en/windows-choosing-package.html
The package formats described in this section are: MySQL Installer MySQL noinstall ZIP Archives MySQL Docker Images Program Database (PDB) files (with file name extension pdb) provide information for debugging your MySQL installation in the event of ...These files are included in ZIP Archive distributions (but not MSI distributions) of ... For MySQL 8.0, ...For ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
To use TLSv1.3, both the MySQL server and the client application must be compiled using OpenSSL 1.1.1 or higher. In particular, note that to use TLSv1.3, both the MySQL server and the client application must be compiled using OpenSSL 1.1.1 or higher. The configuration on both sides must include at least one protocol in common or connection attempts cannot negotiate a protocol to ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file name suffix differs per platform (for example, .so for Unix and Unix-like systems, ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. In MySQL 8.0.21 and later, the data type returned by ROUND() (and TRUNCATE()) is determined according to the ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
For a view to be updatable, there must be a one-to-one relationship between the rows in the view and the rows in the underlying table. For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...For information ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. The search string must be a string value that ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY ...