Menu
Community /Pin to ProfileBookmark
@NogDogApr 24.2018 — #While it has a bit of a "code smell" to me that you want to do that, probably the way I'd do it (if I had to) is to https://dev.mysql.com/doc/refman/8.0/en/json.html
I've used the PostgreSQL jsonb type a bit, but have never tried to update it once stored.@NogDogApr 24.2018 — #The normalized way would be with a separate table with a many-to-one foreign key to the users table, using appropriate joins when retrieving data (maybe using group_concat() to put any associated cars into one delimited string?).
If you want to go with non-normalized data and put them all in one field, then I think you're stuck with doing any editing in the application code and then updating the DB with the revised string (JSON, serialized, whatever) -- which also makes any queries against that data inefficient at best.
Store an array in a table column
Dear users,
I want to create a new table in mysql containing a field which can contain an array (or a json).
I want to perform query to add an element to that array, remove or update ones. In select mode I want to get an array or a json to read all the field content.
How can I do?
Thanks
Sign in
to post a comment7 Comments(s) ↴
0
@NogDogApr 24.2018 — #While it has a bit of a "code smell" to me that you want to do that, probably the way I'd do it (if I had to) is to serialize()unserialize()serialize()0
@NogDogApr 24.2018 — #Never used it, but here's my first result when I googled for "mysql json type": I've used the PostgreSQL jsonb type a bit, but have never tried to update it once stored.
0
@NogDogApr 24.2018 — #If you want to go with non-normalized data and put them all in one field, then I think you're stuck with doing any editing in the application code and then updating the DB with the revised string (JSON, serialized, whatever) -- which also makes any queries against that data inefficient at best.