There was an interesting but hard to read post on StackOverflow about how 'insert select delete'
data from a MySQL JSON data type column. The first line of
the writer's problem is a little confusing '
In order to record user mac_address and count mac_address to
restrict user login's pc or notebook to control user available
max for example (it's work)' but the examples reveled more
about what was desired. The idea was to track MAC address used by
various users and the author of the question was wondering how to
up data a JSON Array of values with JSON_INSERT. INSERT is
for inserting and the better choice would be JSON_ARRAY_APPEND or
JSON_ARRAY_INSERT. But what caught my eye was the
second question: Select sql command for json column ? could be …
Showing entries 1 to 1
Jul
06
2018
Showing entries 1 to 1