By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (val BLOB);
INSERT INTO test VALUES
(UNHEX('7A080040950507000100000000000000320900420200000002000000C04D032E1841712CFFFFFFFF4E0000000100000000000000AD95014202000000020000004040032E78FD712CFFFFFFFFA89C0B0001000000000000003209004202000000020000004040032E1841712C96080040FFFFFFFF01000000F4B55D0CA79501420200000002000000C04D032E10E8712CFFFFFFFF7F4310000100000000000000AD950142020000000200000040CBFA2D78FD682CFFFFFFFF0000000001000000000000003F090042020000000200000040CBFA2D401F6F2CFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000001000000000000004E06004202000000F4011C10C0C7B82EF8A9652CFFFFFFFF000000000100000000000000AA06004202000000020000004040032E4873682CFFFFFFFF000000000100000000000000AA060042020000000200000040CBFA2D20805F2CFFFFFFFF000000000100000000000000360600420'));
SELECT HEX(val) FROM test;
| HEX(val) |
|---|
| 07A080040950507000100000000000000320900420200000002000000C04D032E1841712CFFFFFFFF4E0000000100000000000000AD95014202000000020000004040032E78FD712CFFFFFFFFA89C0B0001000000000000003209004202000000020000004040032E1841712C96080040FFFFFFFF01000000F4B55D0CA79501420200000002000000C04D032E10E8712CFFFFFFFF7F4310000100000000000000AD950142020000000200000040CBFA2D78FD682CFFFFFFFF0000000001000000000000003F090042020000000200000040CBFA2D401F6F2CFFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000000000000000000000000000000000000000000000000000000000000FFFFFFFF0000000001000000000000004E06004202000000F4011C10C0C7B82EF8A9652CFFFFFFFF000000000100000000000000AA06004202000000020000004040032E4873682CFFFFFFFF000000000100000000000000AA060042020000000200000040CBFA2D20805F2CFFFFFFFF000000000100000000000000360600420 |
CREATE TABLE split LIKE test;
INSERT INTO split
WITH RECURSIVE
cte AS ( SELECT UNHEX(LEFT(HEX(val), 8)) part,
UNHEX(SUBSTRING(HEX(val) FROM 9)) slack
FROM test
UNION ALL
SELECT UNHEX(LEFT(HEX(slack), 8)),
UNHEX(SUBSTRING(HEX(slack) FROM 9))
FROM cte
WHERE slack != '' )
SELECT part
FROM cte;
SELECT HEX(val) FROM split;
| HEX(val) |
|---|
| 07A08004 |
| 09505070 |
| 00100000 |
| 00000000 |
| 03209004 |
| 20200000 |
| 00200000 |
| 0C04D032 |
| E1841712 |
| CFFFFFFF |
| F4E00000 |
| 00100000 |
| 00000000 |
| 0AD95014 |
| 20200000 |
| 00200000 |
| 04040032 |
| E78FD712 |
| CFFFFFFF |
| FA89C0B0 |
| 00100000 |
| 00000000 |
| 03209004 |
| 20200000 |
| 00200000 |
| 04040032 |
| E1841712 |
| C9608004 |
| 0FFFFFFF |
| F0100000 |
| 0F4B55D0 |
| CA795014 |
| 20200000 |
| 00200000 |
| 0C04D032 |
| E10E8712 |
| CFFFFFFF |
| F7F43100 |
| 00100000 |
| 00000000 |
| 0AD95014 |
| 20200000 |
| 00200000 |
| 040CBFA2 |
| D78FD682 |
| CFFFFFFF |
| F0000000 |
| 00100000 |
| 00000000 |
| 03F09004 |
| 20200000 |
| 00200000 |
| 040CBFA2 |
| D401F6F2 |
| CFFFFFFF |
| F0000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 0FFFFFFF |
| F0000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 0FFFFFFF |
| F0000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 0FFFFFFF |
| F0000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 00000000 |
| 0FFFFFFF |
| F0000000 |
| 00100000 |
| 00000000 |
| 04E06004 |
| 20200000 |
| 0F4011C1 |
| 0C0C7B82 |
| EF8A9652 |
| CFFFFFFF |
| F0000000 |
| 00100000 |
| 00000000 |
| 0AA06004 |
| 20200000 |
| 00200000 |
| 04040032 |
| E4873682 |
| CFFFFFFF |
| F0000000 |
| 00100000 |
| 00000000 |
| 0AA06004 |
| 20200000 |
| 00200000 |
| 040CBFA2 |
| D20805F2 |
| CFFFFFFF |
| F0000000 |
| 00100000 |
| 00000000 |
| 03606004 |
| 20 |