Splitting of articles by article ids: Difference between revisions
Jump to navigation
Jump to search
m
Splitting of articles by article ids (edit)
Revision as of 10:04, 13 December 2023
, 13 December 2023→Case1: Articles Numbered IDs
(Created page with " == Case1: Articles Numbered IDs == If the article number is a digit, split the article into two parts based on a remainder of 0 or 1, resulting in two nearly equal halves. P...") |
|||
| Line 3: | Line 3: | ||
== Case1: Articles Numbered IDs == | == Case1: Articles Numbered IDs == | ||
If the article number is a digit, split the article into two parts based on a remainder of 0 or 1, resulting in two nearly equal halves. | If the article number is a digit, split the article into two parts based on a remainder of 0 or 1, resulting in two nearly equal halves. | ||
Part1 | |||
(1) Part1 | |||
<pre> | <pre> | ||
SELECT * FROM articles WHERE MOD(article_id, 2) = 0; | SELECT * FROM articles WHERE MOD(article_id, 2) = 0; | ||
</pre> | </pre> | ||
Part2 | (2) Part2 | ||
<pre> | <pre> | ||
SELECT * FROM articles WHERE MOD(article_id, 2) = 1; | SELECT * FROM articles WHERE MOD(article_id, 2) = 1; | ||