Search

Download this Manual
PDF (US Ltr) - 35.0Mb
PDF (A4) - 35.1Mb
Man Pages (TGZ) - 254.9Kb
Man Pages (Zip) - 359.9Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb


Displaying 311 to 315 of 315 total results
https://dev.mysql.com/doc/refman/5.7/en/triggers.html
Important MySQL triggers activate only for changes made to tables by SQL statements. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are ...
https://dev.mysql.com/doc/refman/5.7/en/update-optimization.html
If you do this often, it is very important to use OPTIMIZE TABLE occasionally. An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux.
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
This includes the user account employed to import dumps containing tables with foreign keys. Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
When selecting primary key columns, choose columns with the following characteristics: Columns that are referenced by the most important queries. InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b ...