Splitting of articles by article ids - Revision history

Unknown user at 02:59, 13 December 2023

2023-12-13T02:59:03Z

← Older revision		Revision as of 10:59, 13 December 2023
Line 15:		Line 15:

	== Case2: Articles IDs which mix of string and number ==		== Case2: Articles IDs which mix of string and number ==
	If the article ID consists of numbers or text, it is divided into two parts after a formula calculation with the remainder equal to 0 or 1, resulting in two parts of different quantities.		If the article ID consists of numbers or text e.g. [https://en.wikipedia.org/wiki/Amazon_Standard_Identification_Number Amazon Standard Identification Number], it is divided into two parts after a formula calculation with the remainder equal to 0 or 1, resulting in two parts of different quantities.

	CONV(HEX(article_id), 16, 10) converts HEX(article_id) from hexadecimal (base 16) to decimal (base 10). Then, MOD(CONV(HEX(article_id), 16, 10), 2) computes the remainder when the converted decimal number is divided by 2.		CONV(HEX(article_id), 16, 10) converts HEX(article_id) from hexadecimal (base 16) to decimal (base 10). Then, MOD(CONV(HEX(article_id), 16, 10), 2) computes the remainder when the converted decimal number is divided by 2.

Unknown user at 02:46, 13 December 2023

2023-12-13T02:46:05Z

@@ Line 14: / Line 14: @@
 </pre>
 [[Category:Data_hygiene]]
 [[Category:Data Science]]
 [[Category:MySQL]]

Unknown user: /* Case1: Articles Numbered IDs */

2023-12-13T02:04:56Z

Case1: Articles Numbered IDs

← Older revision		Revision as of 10:04, 13 December 2023
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;

Unknown user: 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..."

2023-12-13T02:04:28Z

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..."

New page

== 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.
Part1
<pre>
SELECT * FROM articles WHERE MOD(article_id, 2) = 0;
</pre>

Part2
<pre>
SELECT * FROM articles WHERE MOD(article_id, 2) = 1;
</pre>

[[Category:Data_hygiene]]
[[Category:Data Science]]
[[Category:MySQL]]