PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. Truncation of excess trailing spaces from values to be inserted into TEXT columns always ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
Errors for invalid values can be suppressed in strict mode if you use INSERT IGNORE or UPDATE IGNORE. For ENUM, the value is inserted as the error member (0). For SET, the value is inserted as given except that any invalid substrings are deleted.
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
For storage engines that support foreign keys, MySQL rejects any INSERT or UPDATE operation that attempts to create a foreign key value in a child table if there is no matching candidate key value in the parent table. MySQL supports foreign keys, ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
SELECT, if IF NOT EXISTS is given and the target table exists, nothing is inserted into the destination table, and the statement is not logged. To ensure that the binary log can be used to re-create the original tables, MySQL does not permit ... You ...
https://dev.mysql.com/doc/refman/5.7/en/data-change-optimization.html
This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. For inserting and updating large volumes of data (known in the industry as ETL, for “extract-transform-load”), sometimes you use other SQL statements or ...Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
HANDLER statement had not been present, MySQL would have taken the default action (EXIT) after the second INSERT failed due to the PRIMARY KEY constraint, and SELECT @x would have returned 2. statement handler_action: { CONTINUE | EXIT | UNDO } ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... The [AS] tbl_name clause is mandatory because every table in a ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. How do I determine the current size of the change buffer? The current size of the change buffer is ...What types of operations modify secondary indexes and result in change buffering? ...