Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
0
votes
1
answer
153
views
Best way to structure data
Already, this is causing problems, as MySQL apparently has a hard limit for how many table joins you can do and I have hit this a few times. …
4
votes
2
answers
46k
views
JSON array format in MySQL not working?
What is the proper way to do a JSON data array in MySQL? …
0
votes
3
answers
7k
views
Working with JSON data MySQL
I am finding that documentation for working with MySQL JSON data is still at this point apparently at it's infancy. Either that or I'm doing it wrong. … I found several docs online, i.e. https://benjaminlistwon.com/blog/working-with-json-data-in-mysql-part-1-of-3/ and others - but neither are working for me. …
-1
votes
Working with JSON data MySQL
I was storing in a [{"key":{"subkey":"val","subkey":"val"}}, {"key":{"subkey":"val","subkey":"val"}}]
I was having to find the data in MySQL using json_extract(field, '$**.key') - which was taking roughly … Guessing this is a bug or something really screwed up in the way MySQL searches for a key - but this fixed it. …
1
vote
2
answers
916
views
Questions since MySQL Startup
Have a weird question / (bug?) here. Using PHP My Admin I installed via apt-get on Ubuntu 13.10
Versions are as follows:
Server version: 5.5.35-0ubuntu0.13.10.2 - (Ubuntu)
Apache/2.4.6 (Ubuntu)
Da …