Skip to main content
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
Results tagged with
Search options not deleted user 35267

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. …
Anthony S.'s user avatar
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 …