PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
(It is not an error to delete nonexisting tokens.) To clear the token list entirely without knowing which tokens are in the list, pass NULL or a string containing no tokens to version_tokens_set(): mysql> SELECT version_tokens_set(NULL); ... The ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Make sure that any error handlers in your application also ROLLBACK incomplete changes or COMMIT completed changes. Handling Deadlocks You might see warning messages referring to “deadlocks” in the MySQL error log, or the output of SHOW ENGINE ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
The strings you specify as input values are automatically encoded as numbers. The index value of the empty string error value is 0. If strict SQL mode is enabled, attempts to insert invalid ENUM values result in an error. Duplicate values in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
Your application code can ensure referential integrity throughout this sequence of operations. For another example, consider an integer counter field in a table CHILD_CODES, used to assign a unique identifier to each child added to table CHILD. For ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
Possible causes include but are not limited to file system errors. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbmtd.html
Trace files are generated by critical errors in ndbmtd processes in a somewhat different fashion from how these are generated by ndbd failures. In the event of a critical error, ndbmtd generates trace files describing what happened just prior to the ... ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
If the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. If the query returns multiple rows, error 1172 occurs (Result consisted of more than one row). An example of such a statement is ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
If the argument size exceeds 511 bytes, an ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE error occurs. If the argument size exceeds 511 bytes, an ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE error occurs. If the argument size exceeds 511 bytes, an ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
The presence of such characters in these values causes the statement to fail with an error. CHANGE REPLICATION SOURCE TO causes the previous values for SOURCE_HOST, SOURCE_PORT, SOURCE_LOG_FILE, and SOURCE_LOG_POS to be written to the error log, ...