Timeline for Working with JSON data MySQL
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 15, 2017 at 23:40 | comment | added | Anthony S. | I did find if I use '$**.Key' json_extract works for verry small arrays but is very slow. It crashed Apache2 when I tried to get a key out in a PDO bound query. | |
| Jan 15, 2017 at 18:46 | comment | added | Anthony S. | So the problem is that JSON_EXTRACT apparently is not returning nested elements based off a passed key. See my update. Maybe again I'm doing it wrong. | |
| Jan 15, 2017 at 18:12 | comment | added | Anthony S. | mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper | |
| Jan 15, 2017 at 18:01 | comment | added | Rick James | True. I should have started with, "Maybe JSON is the wrong solution for your task." What version are you using? New features have been added recently. (No, I don't know if the latest version would address your JSON question.) | |
| Jan 15, 2017 at 17:56 | comment | added | Anthony S. | That did nothing to address my question regarding MySQL JSON querying. | |
| Jan 15, 2017 at 17:18 | history | answered | Rick James | CC BY-SA 3.0 |