MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 201 to 210 of 211 total results

https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html

The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications. (Binary log events differ from scheduled event stored objects.) The ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...

13.2.3 The TIME Type

https://dev.mysql.com/doc/refman/8.0/en/time.html

MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...

10.3.14 Indexed Lookups from TIMESTAMP Columns

https://dev.mysql.com/doc/refman/8.0/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() ...

15.2.17 UPDATE Statement

https://dev.mysql.com/doc/refman/8.0/en/update.html

UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...

3.13 Upgrade Troubleshooting

https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html

A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.0 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...

7.6.6 Version Tokens

https://dev.mysql.com/doc/refman/8.0/en/version-tokens.html

MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. The Version Tokens interface has these characteristics: Version ...

B.3.1 How to Determine What Is Causing a Problem

https://dev.mysql.com/doc/refman/8.0/en/what-is-crashing.html

This can normally be checked by pressing the Caps Lock key. If the Caps Lock light does not change, you have to replace your keyboard. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...

1.2.1 What is MySQL?

https://dev.mysql.com/doc/refman/8.0/en/what-is-mysql.html

MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website (http://www.mysql.com/) provides the latest information about MySQL software. It may be anything ...

14.20.3 Window Function Frame Specification

https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html

The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which ...

Displaying 201 to 210 of 211 total results