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 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.

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);
Vesa Karjalainen's user avatar
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 …
Vesa Karjalainen's user avatar
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 …
Vesa Karjalainen's user avatar
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 …
Vesa Karjalainen's user avatar
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 …
Vesa Karjalainen's user avatar
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 …
Vesa Karjalainen's user avatar
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
Vesa Karjalainen's user avatar