Reputation
951
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
8 30 46
Impact
~230k people reached

  • 0 posts edited
  • 0 helpful flags
  • 116 votes cast
May
22
comment JOIN to read first table and get possible relationship in the second table
@DerekDowney the former one. I added description to the question.
May
22
revised JOIN to read first table and get possible relationship in the second table
added 203 characters in body
May
22
asked JOIN to read first table and get possible relationship in the second table
May
21
awarded  Popular Question
May
13
awarded  Caucus
May
10
awarded  Famous Question
Apr
7
accepted How to JOIN two table to get missing rows in the second table
Apr
5
asked How to JOIN two table to get missing rows in the second table
Mar
27
awarded  Popular Question
Mar
16
awarded  Notable Question
Feb
18
awarded  Popular Question
Jan
9
comment How to re-arrange rows to best fit within groups?
This method will change the order in cat, which is the main requirement. It is needed to preserve the order in each category. The flexibility is where categories are mixed.
Jan
8
awarded  Promoter
Dec
22
revised How to re-arrange rows to best fit within groups?
added 107 characters in body
Dec
22
accepted Multiple “GROUP_CONCAT”s with WHERE clause
Dec
22
comment Multiple “GROUP_CONCAT”s with WHERE clause
I think the first solution is simple and elegant and well fit with my need.
Dec
22
asked Multiple “GROUP_CONCAT”s with WHERE clause
Dec
21
revised How to mix pairs of rows without JOIN (in a temporary table)?
added 2 characters in body; edited title
Dec
21
comment How to mix pairs of rows without JOIN (in a temporary table)?
@JeremySmyth mysql does not support JOIN to self on temporary tables. Temporary tables can be referenced only once in a query.
Dec
21
asked How to mix pairs of rows without JOIN (in a temporary table)?