The MySQL COMPRESS() function is used for the compression of a string. The value returned by the COMPRESS() function is a binary string.
The COMPRESS() function stores non-empty strings as a four-byte length of the uncompressed string, which is then followed by the compressed string. If the string ends with space, a “.” character is added to the string. Also, it should be noted that empty strings are stored as empty strings. The COMPRESS() function accepts one parameter which is the string to be compressed.
- string_to_compress – It is used to specify the plain text string that is to be compressed.
The COMPRESS function in MySQL returns a compressed string.
Supported Versions of MySQL:
- MySQL 5.7
- MySQL 5.6
- MySQL 5.5
- MySQL 5.1
- MySQL 5.0
- MySQL 4.1
Example-1: Implementing COMPRESS function on a string.
Example-2: Implementing COMPRESS function on a string which has a combination of characters and integers.
Example-3: Implementing COMPRESS function on a string and returning the length of the string after compression.
SELECT COMPRESS('geeksforgeeks'), LENGTH(COMPRESS('geeksforgeeks'));
Example-4: Implementing COMPRESS function on a NULL string and returning the length of the string after compression.
SELECT COMPRESS(NULL), LENGTH(COMPRESS(NULL));
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.