Asheavenist Comments - Answer Overflow

Asheavenist

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

I'll try to use opt 3..Thank you for your advice

16 replies

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

Aaah.. I see

16 replies

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

Any advice, sir?

16 replies

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

3- I'll set it max 5 object that will be dynamically change/patch/override because of user state. And each object only has about 5 keys.

16 replies

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

2- I don't know if it is actual JSON column or not. What I know is the data type that currently use on that column is JSON, not TEXT.

16 replies

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

Based on the options above. I choose Table_Opt_1. But still, I'm confuse. Is my choice right..?

16 replies

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

16 replies

•Created by Asheavenist on 10/28/2023 in #back-end

Query on JSON data type. MySQL.

Yes.. And one cell will have max 5 object inside it. Later, object that have an oldest unixTime will change with the new one.

16 replies

•Created by Asheavenist on 7/12/2023 in #back-end

Querying

Thanks.. I dunno if JOIN clause can be used like that. It is work an solved ✨

5 replies