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/group-by-functional-dependence.html
In each case, this relationship applies: {cl.CountryCode} -> {co.Code} cl.CountryCode is itself functionally dependent on {cl.CountryCode, cl.Language} which is a primary key. If in the join result co.Code is NULL-complemented, co.Name is as well.
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Because the interceptor code is only called when SQL statements return errors, it does not impose any performance penalty on the application during normal (error-free) operation. SQLState An error code defined by the JDBC standard, for exception ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
At the SQL level, the output from SHOW WARNINGS and SHOW ERRORS indicates the MYSQL_ERRNO and MESSAGE_TEXT values in the Code and Message columns. SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.0/en/comp-err.html
comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It compiles the errmsg.sys file from text-format error information in MySQL source distributions: As of MySQL 8.0.19, ...Invoke comp_err like this: comp_err [options] comp_err supports the following ...
https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html
If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL server. You can either ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
If the checkpointing is slow and there are so many writes to the database that the log files are full and the log tail cannot be cut without jeopardizing recovery, all updating transactions are aborted with internal error code 410 (Out of log file ...(NDB 8.0.13) This parameter specifies the directory where trace files, log files, pid files and error logs are ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
Condition area list: Condition area 1: error code for condition 1 error message for condition 1 ... Condition area 2: error code for condition 2: error message for condition 2 ... Condition area 3: error code for condition 3 error message for ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. A description of error logging is given later in this section. For example, if you specify a [mysqld] section ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
Symptoms of corrupted tables include queries that abort unexpectedly and observable errors such as these: Can't find file tbl_name.MYI (Errcode: nnn) Unexpected end of file Record file is crashed Got error nnn from table handler To get more ...This ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
If p < 0 or p > 53, an error is returned. If the spatial type combination is permitted but the expression to cast is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If the spatial type combination is permitted but the ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...