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 | |
Results tagged with mysql
Search options not deleted
user 81631
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.
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 …
- 284
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
- 284
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 …
- 284
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 …
- 284
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 …
- 284
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);
- 284
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 …
- 284