Replace document ID with field value

[d47081]

Hello, I want to replace row ID with crc32 hash (as used for identify also) to reduce disk usage:

UPDATE yo_document SET id = crc32url;

This query returns:

ERROR 1064 (42000): P01: syntax error, unexpected identifier near 'crc32url'

crc32url value is yo_document.crc32url field of this table.
In MySQL it works but here I can't update indexes to optimize DB size

p.s. tried REPLACE syntax also but nothing works, I have no idea how to replace ID without creating new table.

[sanikolaev]

You cannot update the id field. Instead, consider using the crc32 value when inserting documents.