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)
-
Finally Windows 7 shows its face, but only Beta version now. The latest version of Microsoft's Windows operating system became popular s...
-
Environment: Visual Studio Code v1.83.1 Symtomps: 1). When you try to debug your Flutter project, you see this error message at the Terminal...
-
The easiest way to do it using the keytool command. Example: keytool -printcert -jarfile <apk_file>
No comments:
Post a Comment