MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 20 of 27 total results

https://dev.mysql.com/doc/refman/8.0/en/create-event.html

For example, EVERY 3 MONTH STARTS CURRENT_TIMESTAMP + INTERVAL 1 WEEK means “every three months, beginning one week from now”. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE ...

13.2.2 The DATE, DATETIME, and TIMESTAMP Types

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

The value '10:45:15' is converted to '0000-00-00' because '45' is not a valid month. The server requires that month and day values be valid, and not merely in the range 1 to 12 and 1 to 31, respectively. MySQL does not accept TIMESTAMP values that ...This section describes their characteristics, how they are similar, and how they ...

27.8 Restrictions on Stored Programs

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

Event timings using the intervals YEAR, QUARTER, MONTH, and YEAR_MONTH are resolved in months; those using any other interval are resolved in seconds. Some of the restrictions noted here apply to all stored routines; that is, both to stored ...

12.16 MySQL Server Locale Support

https://dev.mysql.com/doc/refman/8.0/en/locale-support.html

The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...

6.5.1.2 mysql Client Commands

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

mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: ...

26.3.2 Management of HASH and KEY Partitions

https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html

Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...

Chapter 12 Character Sets, Collations, Unicode

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

MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

lc_time_names Command-Line Format --lc-time-names=value System Variable lc_time_names Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type String This variable specifies the locale that controls the language used to display day and month ... The MySQL server maintains many system variables that affect its ...

8.2.15 Password Management

https://dev.mysql.com/doc/refman/8.0/en/password-management.html

MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...

26.2 Partitioning Types

https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html

However, you can use other date and time functions that return an integer or NULL, such as WEEKDAY(), DAYOFYEAR(), or MONTH(). This section discusses the types of partitioning which are available in MySQL 8.0. This type of partitioning assigns rows ...

Displaying 11 to 20 of 27 total results