MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 141 to 150 of 151 total results

https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html

If a trigger uses a table and the table has changed since the trigger was loaded into the cache, the trigger operates using the outdated metadata. Consequently, stored functions that update the same underlying tables do not execute in parallel. Some ...

23.7 Stored Program Binary Logging

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

These events bring databases up to date from the point of the backup. Triggers can update tables, so error messages similar to those for stored functions occur with CREATE TRIGGER if you do not have the required privileges. If a function that ...

8.4.6 Limits on Table Size

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

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

11.2.3 The TIME Type

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

8.3.11 Indexed Lookups from TIMESTAMP Columns

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() ...

13.2.11 UPDATE Statement

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

UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = ...The SET clause indicates which columns to modify and the values they should be ...

2.10.11 Upgrade Troubleshooting

https://dev.mysql.com/doc/refman/5.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. If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf ...

5.5.5 Version Tokens

https://dev.mysql.com/doc/refman/5.7/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/5.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/5.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, ...

Displaying 141 to 150 of 151 total results