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/insert.html
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... [ON DUPLICATE KEY UPDATE assignment_list] ...[ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ... SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, ...[ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} assignment: col_name = value assignment_list: assignment [, assignment] ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements. The results of a concurrent INSERT may not be visible immediately. The concurrent_insert system variable can be set to ...
https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html
To optimize insert speed, combine many small operations into a single large operation. The size of the table slows down the insertion of indexes by log N, assuming B-tree indexes. You can use the following methods to speed up inserts: If you are ...
https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/midpoint-insertion.html
By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be evicted, but it also supports a more sophisticated method called the midpoint insertion strategy. When using the midpoint insertion strategy, ...The division point between two parts is not fixed, but the key cache management system takes care that the warm part is not “too short,” always containing at least key_cache_division_limit percent of the key cache ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
The following terms are used in describing innodb_autoinc_lock_mode settings: “INSERT-like” statements All statements that generate new rows in a table, including INSERT, INSERT ... “Simple inserts” Statements for which the number of rows to ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
It saves work for the developer, not to have to produce new unique values when inserting new rows. If you have innodb_autoinc_lock_mode=2, which allows higher concurrency for insert operations, use row-based replication rather than statement-based ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. With respect to insertability (being updatable with INSERT statements), an updatable view is insertable if it also satisfies ...