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
How to avoid inner query im MYSQL
Having no idea of your table... The first thing to try would be to
CREATE INDEX i_code ON students (code);
CREATE INDEX i_eid ON students (eid);
0
votes
Mysql Selecting from multiple tables
Instead of
AND Operator.OperatorID = RouteOperators.RouteNumber
you should be joining on
AND Operator.OperatorID = RouteOperators.OperatorID
Learn to use JOIN ... USING(...). You also get a lot …
1
vote
Preferred approach to implement multiple many-to-many relationships?
Since the primary key (page_id, user_id) is same for all roles it would be better to put all roles in a single table, the one you named pages_users.
The question on using role_id and a separate roles …
0
votes
Data design issue. Need help with normalization
(As non-native English speaker, "expanse" is not immediately clear to me)
I'd join the four tables (customer, supplier, employee, expanse) to a single table
(id, group, name)
Depending on your nee …
1
vote
Storing huge file collection in database
As said, file system is for storing files.
Name your files for example with a 16 char pseudorandom (use any hashing algorithm) hex string, then make a directory structure where you have 256 directorie …
1
vote
Join multiple tables for aggregate or create a single table with combined attribes
If you need to have multiple values (like one ART having several AUTHORs), you need this kind of linking. If that is not needed, just have all the ids in ART table.
I'd recommend you move to ART all …
1
vote
Accepted
best way to add Entity id & entity types in database
Make "Entity" an entry in attributes_list and treat it as any other attribute.
Also, do the same for "Category" (whatever your categories might be) and drop Category_details table