PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
To get rid of the warning, execute an UPDATE statement to set the column to some value other than 0. CHECK TABLE Usage Notes for MyISAM Tables The following notes apply to MyISAM tables: CHECK TABLE updates key statistics for MyISAM tables. option: ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. See the section for the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. If you have a problem with indexes not being used when ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
It became a bugfix series as of MySQL 8.0.34 with the introduction of the Innovation and LTS release model. For the syntax required to perform multiple-table updates, see Section 15.2.17, “UPDATE Statement”; for that required to perform ...Why ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
Internally, the implementation uses SELECT, INSERT, UPDATE, and DELETE, but not HANDLER. The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. ON DUPLICATE KEY UPDATE statements, but if a duplicate-key ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-table.html
0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NO ACTION, 32 = ON UPDATE NO ACTION. For related usage information and examples, see Section 17.15.3, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-best-practices.html
Foreign keys also propagate deletes and updates to all affected tables, and prevent insertion of data in a child table if the corresponding IDs are not present in the parent table. While you don't want to commit too often, you also don't want to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-dml.html
Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up queries. INSERT becomes add, UPDATE becomes set, incr or decr, and DELETE becomes delete. Therefore, consider ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
Reducing Transactional Overhead A default value of 1 for daemon_memcached_r_batch_size and daemon_memcached_w_batch_size is intended for maximum reliability of results and safety of stored or updated data. Benchmarks suggest that queries and DML ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
During startup, discovered tablespace files are used instead those referenced in the data dictionary, and the data dictionary is updated to reference the relocated files. For example, after relocating the data directory, you must update the ... The ...