Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/create-table-check-constraints.html
CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to FALSE. CHECK constraints are evaluated for INSERT IGNORE, UPDATE IGNORE, LOAD DATA ... CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/create-user.html
To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system schema. This query displays the row in this table inserted by the statement just shown for creating the user jim@localhost: mysql> ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...