Level 33
Hi @keizah
here MySQL manual says:
To make lookups more efficient, it also sorts the keys of a JSON object. You should be aware that the result of this ordering is subject to change and not guaranteed to be consistent across releases.
Oct 1, 2020
3
Level 17
Prevent json column reorder
Mysql 5.7
I have json column in my model. How I can prevent mysql json field reorder? I want to still have json column type not varchar or something else
Level 50
afaik, you cant prevent that https://dev.mysql.com/doc/refman/5.7/en/json.html#json-normalization
Level 17
I know a way with indexed arrays but I need stick to same json structure as before.
Please or to participate in this conversation.