MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 21 to 30 of 30 total results

« Previous
1
2
3
Next »

https://dev.mysql.com/doc/refman/9.7/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 9.7. This type of partitioning assigns rows ...

26.1 Overview of Partitioning in MySQL

https://dev.mysql.com/doc/refman/9.7/en/partitioning-overview.html

This section provides a conceptual overview of partitioning in MySQL 9.7. For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...

26.3.2 Management of HASH and KEY Partitions

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

1.3 MySQL Releases: Innovation and LTS

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

Subsequent MySQL Innovation and LTS releases use calendar versioning in the YY.M format, where YY represents the year and M represents the scheduled release month. The MySQL release model is divided into two main tracks: LTS (Long-Term Support) and ...

13.2.7 What Calendar Is Used By MySQL?

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

To see how this works, consider the month of October 1582, when the first Julian-to-Gregorian switch occurred. MySQL uses what is known as a proleptic Gregorian calendar. Every country that has switched from the Julian to the Gregorian calendar has ...

18.7.1 MERGE Table Advantages and Disadvantages

https://dev.mysql.com/doc/refman/9.7/en/merge-table-advantages.html

For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. MERGE tables can help you solve the following problems: Easily manage a set of log ...

11.3 Keywords and Reserved Words

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

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

5.3.2 Creating a Table

https://dev.mysql.com/doc/refman/9.7/en/creating-tables.html

You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...

Chapter 4 Downgrading MySQL

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

Monthly Rapid Updates (MRUs) and hot fixes also count as releases in this documentation. Notes Make sure you understand the MySQL release model for MySQL long-term support (LTS) and Innovation releases before proceeding with a downgrade. A ...

2.5.6.1 Basic Steps for MySQL Server Deployment with Docker

https://dev.mysql.com/doc/refman/9.7/en/docker-mysql-getting-started.html

Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...

Displaying 21 to 30 of 30 total results

« Previous
1
2
3
Next »