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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 user 1050

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
The problem is likely that the index on id sorts in the ascending direction, but your ORDER BY is asking for the data in the descending direction. Your ORDER BY has to ask for the data in DESC direct …
answered Jun 10 '13 by Walter Mitty
1
vote
Create one or more new tables that capture the data in event_rules in a more useable form. Then materialize those tables from the existing table. Without more details, I can't say exactly what tho …
answered Feb 25 '12 by Walter Mitty
1
vote
I have only seen one instance where this made a difference. The int was being cast as a string, and then sorted alphabetically. The zero fill prevented a strange sort order, such as 10 coming before …
answered Feb 8 '15 by Walter Mitty
1
vote
For a few years, I contracted with large firms to come in and fix up databases in sad need of repair. The databases were broken in a variety of ways. 100 tables strikes me as the middle of the range. …
answered Sep 16 '18 by Walter Mitty
1
vote
Other answers have addressed the main issues. There are two side issues worth noting. The first is mutability and the second is trustworthiness. It is usually necessary, or at least very desirable, …
answered Jul 6 '16 by Walter Mitty
2
votes
I see from your diagram and from the columns named lft and rgt that you are using the nested sets technique for organizing the categories into a tree. So far so good. Now all you need to do is add …
answered Jan 19 '15 by Walter Mitty
1
vote
One way to understand what's going on with normalization is to find out what normalization buys you. In other words, what's going to happen if you depart from any given normal form? For normalizat …
answered Mar 25 '15 by Walter Mitty
0
votes
You need three more constraints on each of your linkage tables. The first constraint says the the two FKs, taken together, are unique. The other two constraints say that neither of the FKs can be NU …
answered May 14 '13 by Walter Mitty
1
vote
I think that your question is really about relationships of degree 3, sometimes called "ternary relationships". There is a diagram here that illustrates a ternary relationship between course, subject …
answered Feb 24 '17 by Walter Mitty
1
vote
Is it safe to assume that for every relevant post the tag 88 occurs exactly once and the tag 5 also occurs exactly once? Is there an index on post_id in table post_tags? If the answer is yes to bot …
answered Feb 27 '12 by Walter Mitty
4
votes
This is really a fundamental conceptual question concerning the basics of the relational model of data. Your desire to learn how this really works is admirable, and people should tolerate dumb questi …
answered Jun 21 '14 by Walter Mitty
3
votes
case, I would play around with leaving out the index you've called fk_merchant_appointment. It may be the case that MySQL will use the apointments_index instead, and get most of the benefits with less cost. I can't say for sure. …
answered Jun 6 '15 by Walter Mitty
-1
votes
If the relationship is really one to zero or one, you may be dealing with a class/subclass situation. In ER modeling this is known as generalization/specialization. If this applies to your case, I …
answered Jun 5 '13 by Walter Mitty
0
votes
Your best bet to get some well researched guidance on this topic is to look up "Extract, Transform, and Load" processing, abbreviated ETL. ETL processing has been extensively studied, especially as …
answered Aug 11 '15 by Walter Mitty
4
votes
Your case is an instance of class/subclass modeling. Or, as you have diagrammed it in ER, generalization/specialization. There are three techniques that will help you design mysql tables to cover …
answered Mar 11 '13 by Walter Mitty

15 30 50 per page