PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
Displaying 311 to 316
of 316 total results
- « Previous
- 30
- 31
- 32
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...
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 ...