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/problems-with-float.html
The FLOAT and DOUBLE data types are subject to these issues. The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to floating-point error. An implication of the preceding issues ... Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
This is because MySQL relies on the operating system to perform file system caching for data reads, so you must leave some room for the file system cache. Unless otherwise specified, the default file location is the data directory if the value is a ...Most system variables can be set at server startup using options on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
In other cases, the error log directory must be writable or the error log must be present and writable for the user running the mysqld process. This script assists in creating the error log file only if the log location matches a pattern ...One ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
This includes the server's data directory containing the files that implement the privilege tables. Encryption helps to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from ...Make sure that the only Unix user account with read or write privileges in the database directories is the account that is used for running ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns an error if ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE is specified. The innodb_file_per-table option does not affect the creation of InnoDB temporary tables. LIKE to ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
Tables created in the mysql tablespace, the InnoDB system tablespace (innodb_system), or general tablespaces include a TABLESPACE attribute in the table definition, which defines the tablespace where the table resides. LIKE preserves the TABLESPACE ...LIKE does not preserve any DATA DIRECTORY or INDEX DIRECTORY table options that were specified for the original table, or any foreign key ...LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-change-path-proc.html
Note Starting with MySQL Installer 1.4.39, if you move the data directory of an installed server manually, MySQL Installer identifies the change and can process a reconfiguration operation without errors. You can change the default installation ...
https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html
When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query ... A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installation-windows-path.html
Warning You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can leave you with a malfunctioning or even unusable system. To make it easier to invoke MySQL ...