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/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Numbers may be preceded by - or + to indicate a negative or positive value, respectively. Numbers represented in scientific notation ...
https://dev.mysql.com/doc/refman/8.0/en/option-defaults-equals.html
Due to this behavior, problems can occasionally arise when no value is provided for an option that expects one. Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-log-status-table.html
It also provides relevant information for individual storage engines, such as the last log sequence number (LSN) and the LSN of the last checkpoint taken for the InnoDB storage engine. The log_status table provides information that enables an ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. The in-memory tables become effective for access control at that point. If you modify the grant ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
For example, if you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/refman/8.0/en/shutdown.html
A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, and sending an OK packet to the client. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-auto-increment-columns.html
This indicates how much of the sequence of values is “used up.” . This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-component.html
As a result, unloaded components are not loaded during the startup sequence for subsequent server restarts. A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. It requires the ...