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/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
Depending on how you set the striping parameters and number of disks, you may get differences measured in orders of magnitude. Data inconsistencies introduced due to messages received out of order or lost network traffic. This section describes ...
https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html
DISTINCT combined with ORDER BY needs a temporary table in many cases. Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. In most cases, a DISTINCT clause ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
This is useful when you want to put data into ordered groups. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Moreover, distinguishing characters is not the same as ordering them per the conventions of a given CJK language. This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
This means that you should not chain two servers together in a two-way replication relationship unless you are sure that your updates can safely happen in any order, or unless you take care of mis-ordered updates somehow in the client code. In the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html
By default, triggers that have the same trigger event and action time activate in the order they were created. To affect trigger order, specify a clause after FOR EACH ROW that indicates FOLLOWS or PRECEDES and the name of an existing trigger that ...Where can I find the documentation for MySQL 8.0 triggers? ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall”. This section describes how to configure MySQL Enterprise Firewall using SQL ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
If corruption within the table data prevents you from dumping the entire table contents, a query with an ORDER BY primary_key DESC clause might be able to dump the portion of the table after the corrupted part. If a high innodb_force_recovery value ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
<collation name="latin1_fulltext_ci" id="1025"/> </charset> Declare the sort order for the collation in the latin1.xml file. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...