Alter Table Table_Name
Partition By Range (Field_Name)
(
Partition `201101` Values Less Than (201102),
Partition `201102` Values Less Than (201103),
Partition `201103` Values Less Than (201104),
Partition `201104` Values Less Than (201105),
Partition `201105` Values Less Than (201106),
Partition `201106` Values Less Than (201107),
Partition `201107` Values Less Than (201108),
Partition `201108` Values Less Than (201109),
Partition `201109` Values Less Than (201110),
Partition `201110` Values Less Than (201111),
Partition `201111` Values Less Than (201112),
Partition `201112` Values Less Than (201201)
);
The `201101` represents the partition name while the 201102 represents the Less Than value.
Programming Explorer : This is the place that I would like to share with you about my IT knowledge and experience. Some of the articles are copied from others in the internet. Some are originally come from my findings.
Subscribe to:
Post Comments (Atom)
-
If your environment is something like below: Windows operating system, either 10 or 11 Python 3.13 You are trying to install pymssql , and Y...
-
Finally Windows 7 shows its face, but only Beta version now. The latest version of Microsoft's Windows operating system became popular s...
-
You may refer to the sample codes below from us. We use Windows platform as an example: import webbrowser def main(): fUrl: str = 'h...
No comments:
Post a Comment