PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
If there is a difference between the tables, an error is returned and the statement fails. If you encounter an error message similar to ERROR 1017 (HY000): Can't find file: 'tbl_name.MRG' (errno: 2), it generally indicates that some of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. Normally, myisamchk or myisamchk --medium-check should be able to determine whether there are any errors in ...This is the default operation if you specify no option that selects an operation type ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. --wait, -w Command-Line Format --wait Type Boolean Default Value false Instead of terminating with an ... The options described in this section can be used for any type of table maintenance operation performed by ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
MaxNoOfSavedMessages: Maximum number of error messages to write in error log and maximum number of trace files to retain. MaxStartFailRetries: Maximum retries when data node fails on startup, requires StopOnError = 0. RestartOnErrorInsert: Control ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-config.html
If the node having this ID is not a data node, ndb_config fails with an error. --core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in debugging. This tool extracts current configuration information for data ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Each name in this list must be the name of an existing partition or subpartition of the specified table; if any of the partitions or subpartitions are not found, the statement fails with an error (partition 'partition_name' doesn't exist). Explicit ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. The name of the performance_schema database is ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. Control over handling of ... MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
An error occurs for old accounts that do not exist or new accounts that already exist. As of MySQL 8.0.22, RENAME USER fails with an error if any account to be renamed is named as the DEFINER attribute for any stored object. (That is, the statement ... RENAME USER old_user TO new_user [, old_user TO new_user] ...