MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 181 to 186 of 186 total results

« Previous
17
18
19
Next »

https://dev.mysql.com/doc/refman/9.7/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/9.7/en/upgrade-troubleshooting.html

In this case, check the date for your mysql.h file and libmysqlclient.a library to verify that they are from the new MySQL distribution. A schema mismatch in a MySQL 9.6 instance between the .frm file of a table and the InnoDB data dictionary can ...

B.3.1 How to Determine What Is Causing a Problem

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

Check also that all your libraries (such as glibc) are up to date. 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 ...

1.2.1 What is MySQL?

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

The database enforces these rules, so that with a well-designed database, your application never sees inconsistent, duplicate, orphan, out-of-date, or missing data. MySQL, the most popular Open Source SQL database management system, is developed, ...

14.20.3 Window Function Frame Specification

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

(For details about the permitted units specifiers, see the description of the DATE_ADD() function in Section 14.7, “Date and Time Functions”.) RANGE on a numeric or temporal expr requires ORDER BY on a numeric or temporal expression, ... The ...

13.2.4 The YEAR Type

https://dev.mysql.com/doc/refman/9.7/en/year.html

The YEAR type is a 1-byte type used to represent year values. It can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) with an explicit display width. Note The YEAR(4) data type using an explicit display ...