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/miscellaneous-functions.html
ON DUPLICATE KEY UPDATE statement, you can use the VALUES(col_name) function in the UPDATE clause to refer to column values from the INSERT portion of the statement. In other words, VALUES(col_name) in the UPDATE clause refers to the value of ...The ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
For an InnoDB table, the statement is considered a single transaction, so the presence of any unmatched values causes the statement to fail completely, and no rows are inserted. For a table using a nontransactional storage engine such as MyISAM, any ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... To see how this occurs, first insert a row into e2 that is outside the boundaries of the ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
In the event that the target type cannot represent the value being inserted, a decision must be made on how to handle the conversion. Lossy conversion is handled by inserting only the first N characters of the string on the replica, where N is the ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
The highest value present in the col column prior to the INSERT is 31, and the next available value in the AUTO_INCREMENT series is 35, so the inserted values for col begin at that point and the results are as shown for the SELECT query. If the ...
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. Before MySQL 5.7.6, because v2 has a LOCAL check option, inserts are tested only against the ...It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
The WITH CHECK OPTION clause can be given to constrain inserts or updates to rows in tables referenced by the view. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. The WITH ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, any rows preceding the error have already been inserted. Suppose that a table t is defined as follows: CREATE TABLE t (i ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
MyISAM Tables In MyISAM tables, deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. DELETE QUICK is most useful for applications where index values for deleted rows are replaced by similar index ...